home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Business Heaven
/
Business Heaven.iso
/
dayo
/
dayo_qt
/
dayoquo.doc
< prev
next >
Wrap
Text File
|
1992-06-02
|
316KB
|
3,932 lines
╔════════════════════════════════════════════════════════════════════════════╗
║ ║
║ ║
║ ║
║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║
║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║
║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║
║ ║
║ ║
║ ║
║ ║
║ ▄███▄ █░ █░ ▄███▄ ▄█████▄ ████▄ ▄██▄ ║
║ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║
║ █░ █░ █░ █░ █░ █░ █░ █▄▄▄ ▀██▄ ║
║ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║
║ ▀███▀█░ ▀███▀ ▀███▀ █░ ████▀ ▀██▀ ║
║ ║
║ ║
║ ║
║ ║
║ SALES ORDER QUOTES FOR THE DAYO MODULES ║
║ ║
║ ║
║ Copyright 1990-1992, TJS LAB, PO Box 585366, Orlando, Florida 32858-5366 ║
║ ║
║ ║
║ ║
║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║
║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║
║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║
║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║
║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║
║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║
║ ▀▓▓▓▀ & LAN █████■████▌ O A ║
║ Applications ▐███████████ N R ║
║ ┌─┐ ┌─┐ ███████████▌ S E ║
║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║
║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║
║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║
║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║
║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║
║ █ G ║
║ PO BOX 585366, ORLANDO, FLORIDA 32858-5366 ▄▄▄▄▀ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO Quotes, TJS LAB Orlando, Florida
■ SOFTWARE SUPPORT POLICY
1. TJS LAB does not support users of unregistered DAYO products with the
exception of installation questions.
2. Support (included with registration) remains in effect for 3 months
after date of registration or upgrade.
3. Support is available through the following methods:
- Phone/Voice Mail: (407) 291-3960/6987
- U.S. Mail: TJS LAB, PO Box 585366, Orlando, FL 32858-5366
- Compuserve Easyplex: 76367,1401
4. Any errors ("bugs or features') in the program will be corrected and
the 'fix' sent promptly (via modem if possible).
DAYO Quotes, TJS LAB
Table of Contents
Page Subject
──── ──────────────────────────────────────────────────────────
1...... INTRODUCTION
2...... COPYRIGHT/LICENSE
2...... DISCLAIMER
2...... REQUIREMENTS ***
2...... SETUP
3...... MAIN MENU
3...... PASSWORD/NAME
4...... QUOTES MENU
4...... KEY QUOTE CONFIGURATION SETTINGS
5...... KEY INVENTORY & CUSTOMER FIELDS
6...... CREATE QUOTE
6...... QUOTE INITIAL SCREEN
7...... SELECT CUSTOMER OR QUOTE
7...... QUOTE DETAIL SCREEN
8...... SELECT DETAIL ITEM
8...... EDITING SELECTED DETAIL ITEMS
8...... RECALL A TEMPLATE
9...... MULTIPLE PRICING
10...... FINAL QUOTE EDIT SCREEN
10...... MULTIPLE SHIP TOS
11...... LAST CHANCE TO ABORT QUOTE
12...... PRINTER OFFLINE MESSAGE
12...... DATABASE POSTING
12...... BROWSE HEADER QUOTE RECORDS
13...... EDIT HEADER QUOTE RECORDS
13...... ADD A BLANK QUOTE HEADER RECORD
13...... DELETE QUOTE HEADER RECORD
14...... BROWSE DETAIL QUOTE RECORDS
15...... ADD A BLANK QUOTE DETAIL RECORD
15...... DELETE QUOTE DETAIL RECORD
15...... TEMPLATES
17...... CREATE NEW TEMPLATE
17...... DELETE TEMPLATE ITEM
17...... REPRINT A QUOTE
18...... CUSTOMERS
18...... CONFIGURATION
19...... CONFIGURATION DEFAULT SETTINGS
20...... CONFIGURATION MENU
20...... COMPANY NAME, ADDRESS & TELEPHONE
21...... AUTOMATICALLY PRINT THE QUOTE
21...... LAST QUOTE NUMBER
21...... QUOTE PRINTER TYPE
22...... QUOTE PRINTER PORT
22...... QUOTE COPIES
DAYO Quotes, TJS LAB
Table of Contents
Page Subject
──── ──────────────────────────────────────────────────────────
22...... DEFAULT TAX CODE
22...... DEFAULT QUOTE TYPE
23...... ALLOW BROWSE EDITING
23...... DEFAULT TERMS
23...... DEFAULT SHIPPER/METHOD OF SHIPMENT
24...... INVENTORY DATABASE LOCATION/DIRECTORY
24...... CUSTOMER DATABASE LOCATION/DIRECTORY
24...... POS DATABASES LOCATION/DIRECTORY
24...... PRICE BOOK DATABASE LOCATION/DIRECTORY
25...... REPORT PRINTER TYPE
25...... REPORT PRINTER PORT
25...... VISUAL INDEXING
26...... TAX THE ADJUSTMENT FIELD ON THE INVOICE
26...... DEFAULT FREIGHT PERCENTAGE
26...... TAX THE FREIGHT FIELD ON THE INVOICE
27...... USE MULTIPLE PRICES - MULTIPLE PRICE TABLES
27...... USE 2ND TAX
28...... AUTOMATIC DAILY INDEXING
28...... COLOR MONITOR
28...... COLOR INTENSITY
29...... REPORTS
30...... QUOTES HEADER REPORTS
30...... QUOTES DETAIL REPORTS
31...... CUSTOMER BILL TO ADDRESS LABELS
32...... TEMPLATES ALL REPORT
32...... DATABASE STATUS REPORT
34...... CONFIGURATION STATUS REPORT
35...... PRINTER DRIVER (SETUP)
35...... PRINTER DRIVER OPTIONS
36...... CHANGE DEFAULT PRINTER
37...... FULL SCREEN EDIT - F2
37...... PRINTER DRIVER DATABASE FIELD DEFINITIONS
38...... MISCELLANEOUS ROUTINES
38...... MISC Routines Menu:
39...... APPEND FROM
41...... BROWSE DATABASES
43...... COPY (.DBF) TO
45...... CREATE DATABASE
47...... DELETE RECORDS
48...... ERASE FILE
48...... EXIT TO DOS
49...... INDEX A DATABASE
50...... LIST FIELDS
53...... MODIFY DATABASE
54...... PACK DATABASE
DAYO Quotes, TJS LAB
Table of Contents
Page Subject
──── ──────────────────────────────────────────────────────────
55...... RECALL RECORDS
55...... RETURN TO MENU
55...... RUN (DOS COMMAND)
56...... SIMPLE EDITOR
57...... SORT DATABASE
58...... TYPE (PRINT) FILE
59...... ZAP DATABASE
61...... HELP SCREENS
62...... EXPANDED HELP
63...... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
64...... VIEW DOCUMENTATION ONSCREEN
65...... DATABASE STRUCTURE
70...... DATA DICTIONARY
72...... DAYO QUOTES MAINTENANCE & QUIRKS
74...... TJS 'Computer' LAB
DAYO Quotes, TJS LAB Page: 1
■ INTRODUCTION
DAYO Quotes creates sales order quotes based on the DAYO Inventory,
Customer, and other DAYO databases. Quotes can be printed on a standard
printer or a Hewlett Packard (tm) Laserjet compatible printer. The quote can
be printed on a pre-printed form, on the Laser printer in a special laser
format, or as a standard/default form. This application is multiuser; capable
of supporting many users when used on a PC based LAN/Network. It can, however
be run (like all DAYO products), as a 'standalone' application. DAYO Quotes
closely models itself after the DAYO POS (Point of Sale) application, and is
totally integrated with that application.
Some of the DAYO Quotes highlights are:
Multiuser (ie: Novell)
Templates
Databases are dBase (tm) compatible
HP Laser Special Quotes
Preprinted Quotes forms support
Standard Quotes forms
Customer Bill To/Mailing Address Labels
Special Customer Pricing (With DAYO Price Book)
Margin
Discount Off List
Fixed
Configuration Settings
Sales Tax Codes
Terms Codes
Invoice Type Codes
Shippers/Method of Shipment Codes
Passwords (with DAYO Passwords)
Reports
Other DAYO Products:
DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving
DAYO POS Point of Sales (Billing & Invoicing)
DAYO Price Books Special pricing for your customers as well as a wide
range of product catalogs/reports
DAYO AR Accounts Receivable
DAYO AP Accounts Payable
DAYO BO Back Orders
DAYO EOP End Of Period Posting
DAYO Passwords Password protect your DAYO system
DAYO Smart Reports A variety of reports pertaining to the above modules
DAYOX Network/LAN Index Maintenance Utility
DAYO Quotes, TJS LAB Page: 2
■ COPYRIGHT/LICENSE
This manual and software is copyrighted with all rights reserved by
TJS LAB. No copying of this manual or software is authorized without
the prior written consent of TJS LAB. The only exception to this rule is the
making of backup copies of registered software disks. No RESALE of any part
of the source codes is authorized without the prior written consent of
TJS LAB. TJS LAB retains all rights to DAYO Quotes software, documentation,
and source codes.
■ DISCLAIMER
No warrant is made that this software will work in all environments,
or with all resident programs and hardware configurations. TJS LAB has
tested this software in many environments and found it to perform as
expected, however, this software is licensed "AS IS".
TJS LAB will not be liable for any damage done to your data, hardware
and/or software systems as a result of using DAYO Quotes.
■ REQUIREMENTS ***
IBM or Compatible CPU
640K memory
* DOS 3.3 or above
Hard Disk
■ SETUP
To setup DAYO Quotes, run the SETUP program found on the Menu or Update
& Conversion disk, or install the contents of the DAYO Quotes floppy disk
into a directory on your hard disk (ie: \DAYOQUO). When you run DAYO Quotes
for the first time, it will create all the database, index, and configuration
files it requires for operation. If you are using other DAYO modules, be sure
to enter the location of these databases into the DAYO Quotes configuration.
DAYO Quotes, TJS LAB Page: 3
■ MAIN MENU
After a few moments and possibly a reindex, the main menu will appear:
DAYO Quotes Version 4.00 TJS LAB, Inc. ┌─────[June 1992]────┐
Copyright (c) 1989-1992, All Rights Reserved │S M T W T F S │
╓────────────────────╖ ├────────────────────┤
║ 1 QUOTE ║ ██▄████░ ▄███▄ ██░ ██░ ██████░ │ 1 2 3 4 5 6│
╟────────────────────╢ ██░ ██░ ██░██░ ██░ ██░ ██░ ██░ │ 7 8 9 10 11 12 13│
║ 2 CUSTOMERS ║ ██░ ██░ ██░██░ ▀████▀ ██░ ██░ │14 15 16 17 18 19 20│
╟────────────────────╢ ██░ ██░ ██▀▀▀██░ ▀██▀ ██░ ██░ │21 22 23 24 25 26 27│
║ 3 CONFIGURATION ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ │28 29 30 │
╟────────────────────╢ █▀█████░ ██░ ██░ ██░ ██████░ │ │
║ 4 REPORTS ║ └────────────────────┘
╟────────────────────╢ ╓────────────────────────────────────────────────╖
║ 5 MISC ROUTINES ║ ║ DAYO QUOTES STATISTICS ║
╟────────────────────╢ ║ DATABASE NAME RECORDS SIZE ║
║ 6 EXIT ║ ║ INV.DBF Inventory 228 81K ║
╚════════════════════╝ ║ QUOTES.DBF Quote Header 15 7K ║
Select Option ║ QUOTESD.DBF Quote Detail 77 12K ║
║ CUSTOMER.DBF Customers 4 3K ║
╚══════════[ Press Alt F9 To Reindex ]═══════════╝
▄█████▄ ██░ ██░ ▄█████▄ ▄██████▄ █████▄ ▄████▄
██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
██░ ██░ ██░ ██░ ██░ ██░ ██░ ██▄▄▄ ▀████▄
██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░
▀████▀██░ ▀█████▀ ▀█████▀ ██░ █████▀ ▀████▀
View-Adjust-Create Quote
The left side of the screen is the actual main menu. The calendar and
logos are just 'art'. The DAYO Quotes Statistics box (center right) contains
the number of records and size (in kilo bytes) of the main databases (there
are many others!).
■ PASSWORD/NAME
From the main menu you can enter any of the modules, but not until you
enter your name (or password if using DAYO Password):
┌────────────────────────────────────────────────────────────────────────────┐
│┌──────────────────────────────────────────────────────────────────────────┐│
││ Enter Your Name: TOM JOHNSON ││
│└──────────────────────────────────────────────────────────────────────────┘│
└────────────────────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: 4
■ QUOTES MENU
╔════════════════════════╗
║ QUOTES MENU ║
╟────────────────────────╢
║ CREATE QUOTE ║
║ BROWSE QUOTE HEADERS ║
║ BROWSE QUOTE DETAIL ║
║ BROWSE/CREATE TEMPLATE ║
║ REPRINT QUOTE ║
╟────────────────────────╢
║ Select Option ║
╚════════════════════════╝
Quotes are created by first selecting a customer, then selecting the
detail line items, or by recalling/adding a template.
■ KEY QUOTE CONFIGURATION SETTINGS
Many configurations can be made that affect the quotes process. The
following configuration settings are the key ones. These settings should be
determined and set prior to any creation of quotes! Be sure you understand
each option before creating your first quote. The default settings may not
be what you require!
Auto Print Quote - Prints Quote automatically after completion.
Defaults to 'Y'
Last Quote Number - Your Quote numbers will start (default) at '1'
unless you change this
Quote Printer Type - You can select 1 of 3 Quote printout types:
Standard, HP Laser, or Pre Printed
Defaults to STANDARD
Quote Printer Port - Defaults to LPT1
Quote Copies - Defaults to 1
Default Tax Code - Customers with no TAXRATE will receive the sales
tax rate associated with this tax code. Defaults to
'1'
Default Quote Type - This becomes the default TYPE (ie: REG), for
customers with no TYPE field entered in their
customer records. Defaults to 'REG'
Default Shipper - This is the default Shipper/Method of Shipment for
customers that do not have it entered on their
records. Defaults to PICKUP
Default Terms - This is the default Terms (ie: CASH, NET 30), for
those customers that do not have it entered on
their records. Defaults to CASH
DAYO Quotes, TJS LAB Page: 5
Inventory Location - Defaults to current drive/directory, but may reside
in the \DAYOINV\ directory...
Customer Location - Defaults to current drive/directory, but may reside
in the \DAYOAR\ directory...
POS Location - Defaults to current drive/directory, but may reside
in the \DAYOPOS\ directory...
Price Book Location - Defaults to current drive/directory, but may reside
in the \DAYOPB\ directory...
■ KEY INVENTORY & CUSTOMER FIELDS
To make it possible for you to create a Quote, you must have at least
one customer and one item in your inventory. Key fields these customer and
inventory records greatly affect the quotes process.
For instance, the inventory database (INV.DBF) has the following key fields:
The PRICE field obviously determines what is to be charged the customer/
client. The only exception to this is the DAYO Price Book pricing methods.
Inventory items can be TAXABLE or not.
Apart from the obvious benefit of having the customers name and address, the
customer database (CUSTOMER.DBF) also has its important quote related fields:
The tax rate field (TAXRATE) field determines the sales tax rate to be
charged this customer/client.
The TERMS field determines how the customer/client is to pay (or not to
pay), for the items. For example, a CASH terms customer will pay
'on the spot', whereas a customer with terms of 'NET 30' has thirty days to
make payment for the quote (later made into an invoice).
The SHIPPER field alerts you to how the customer wants the items shipped
to him.
The TYPE field is perhaps the most important. It is this field that
determines how the quote data will be posted to the databases after it gets
invoiced. There are 8 default quote/invoice types, but more can be added. It
is imperative that these default TYPE entries NOT be altered. Any additional
TYPE entries will be handled (posted), just like the REG (Regular Sale) type.
REG - REGULAR SALE
Ret - RETURN
Ref - REFUND
DIR - DIRECT SHIPMENT
SPC - SPECIAL
LON - LOANED
EXC - EXCHANGE
TRN - TRANSFER
VOD - VOIDED
DAYO Quotes, TJS LAB Page: 6
The PBM (Price Book Margin) and PBL (Price Book List) fields work with
DAYO Price Book to provide special pricing to the customer.
■ CREATE QUOTE
Okay, time to create a Quote!
After selecting the QUOTE option, the initial Quote screen will
appear (below). Note that much of the customer information is printed atop
the screen. All other customer data is accessible by simply 'browsing'
through the customer database; by using one of the FIND function keys
(F5,F6,F7,F8), or by using the right/left/PgUp/PgDn arrow keys. There are
more fields to the right of the initial screen! Press F1 (for HELP), if you
want more information about the special keys involved in a browse screen...
■ QUOTE INITIAL SCREEN
DAYO Quotes Version 4.0 TJS LAB QUOTE ┌───[February 1992]──┐
╔════════════════════════════════════════════════════════════════════════════╗
║ BILL TO: SHIP TO: ║
║ JOE MORGAN JOE MORGAN WAREHOUSE #34 ║
║ PO BOX 334366 890 EAST LOWELL ROAD ║
║ 89033 WINTER PARK STREET ║
║ CASSELBERRY, FL 34330 ORLANDO, FL 55555-5555 ║
║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║
║ 1234 REG JD COD UPS GROUND ║
║ PHONE ATTN CREDIT LASTDATE ║
║ (407) 291-5555 SAM SPELDING 7000.00 12/28/91 ║
╚═══════════════════[ Select The Customer To Be Quoted ]═════════════════════╝
CUSTOMER NAME ATTN
───────────╥────────────────────────────────╥─────────────────────────────────
1 ║ TOM JOHNSON ║ TOM
2 ║ JANICE ICE COMPANY ║ JOSE
3 ║ JOE MORGAN ║ SAM SPELDING
4 ║ MORGAN ENTERPRISES, INC ║
5 ║ HARRODS ║ DING MING
4 ║ SALLEY MORGAN ║
5 ║ CATHY MORGAN ║
Esc (Abort/Exit) Enter/Return (Select) F1 (Help) Ctrl N (Add)
Find: F5 (Customer) F6 (Name) F7 (Ship To) F8 (Phone) F9 (Zip Code)
1/20
DAYO Quotes, TJS LAB Page: 7
■ SELECT CUSTOMER OR QUOTE
Select (highlight), a customer you wish to create a quote for, then press
Enter/Return. Note, if so configured (in your Configuration menu), you can
press Ctrl N to add/create a new customer if you have the configuration
setting set to allow the adding of new customer records.
■ QUOTE DETAIL SCREEN
The next screen remains the same ONLY in that the customers Bill To
address remains on the screen (top left). The little box on the upper right
of the screen will contain a scrolling list of selected detail items as well
as a total cost of the detail items and the number of detail lines. The
center of the screen contains key information about the currently highlighted
inventory item.
DAYO Quotes Version 4.0 TJS LAB QUOTE ┌───[February 1992]──┐
╔══════════════════════════════════════╦══[ Detail Items ]═══════════════════╗
║ BILL TO: ║ Subtotal: 75.76 Lines: 2 ║
║ JOE SPACE ║ Item Qty Extended ║
║ PO BOX 9930 ║ 1000 10 55.56 ║
║ ║ 324233-A 1 20.20 ║
║ LANCASTER, ST 55555 ║ ║
╠═══[ Item Info ]══════════════════════╩═════════════════════════════════════╣
║ Item Vendor Item Vendor Description Type ║
║ 1232 ABC-1232 ABC # 45 BOLT R ║
║ Onhand OnOrder Cost Retail Price Adj. Price PB Method ║
║ 10 0 1.00 3.00 2.00 2.00 DEF **.***║
╚═══════════════[ Select The Inventory Items To Be Quoted ]══════════════════╝
ITEM DESC ONHAND ONORDER BO
──────────────╥────────────────────────────────╥─────────╥─────────╥──────────
1212 ║ # 12 BOLT ║ 10 ║ 0 ║ 0
1214 ║ # 32 BOLT ║ 10 ║ 0 ║ 0
1216 ║ # 33 BOLT ║ 10 ║ 7 ║ 0
1217 ║ # 40 BOLT ║ 10 ║ 3 ║ 0
1219 ║ # 42 BOLT ║ 10 ║ 0 ║ 0
1232 ║ # 45 BOLT ║ 10 ║ 12 ║ 7
1245 ║ RED ALUMINUM SIDING TYPE 3 ║ 10 ║ 0 ║ 0
Esc (Exit) Enter/Return (Select) F1 (Help) F2 (Edit) F3 (Template)
Find: F5 (Item) F6 (Desc) F7 (Vendor) F8 (Vendor Item) F9 (Type)
18/74
DAYO Quotes, TJS LAB Page: 8
■ SELECT DETAIL ITEM
To select an inventory item for addition to a Quote, highlight the item,
then press Enter/Return. The lower center of the screen will clear and a
prompt will appear allowing you to alter the PRICE and the quantity to be
quoted, ie:
╚═══════════════════════════[ Add Item To Quote ]════════════════════════════╝
Price: 100.01
Quantity: 3
■ EDITING SELECTED DETAIL ITEMS
Any time during the item selection process, you can edit items already
selected by pressing the 'F2' key. This will bring up a 'browse' screen of
just those items you have selected, ie:
Item Description Qty Price Extended
145355 BIG WIDE MOUTH JAR #45 10 31.00 310.00
154242-12 LITTLE JAR 1 20.20 20.20
457823 SMALL JAR 1 55.56 55.56
654555 BIG NOSE JAR 1 323.23 323.23
745745 JAR 1 100.01 100.01
856566-YOI GREEN JAR 10 0.00 0.00
Esc (Abort/Exit) Enter/Return (Edit) Ctrl U (Delete)
Pressing Enter/Return again will let you change the PRICE and/or quantity
of the currently highlighted detail item. 'Ctrl U' removes the detail line
item from the quote. Exit this screen by pressing 'Esc' only once.
■ RECALL A TEMPLATE
If you have created templates, you can recall them from the QUOTE DETAIL
screen by pressing 'F3' and then entering in the template number, ie:
Enter Template Number: 50
Note, templates are created in another QUOTE menu option routine...
DAYO Quotes, TJS LAB Page: 9
■ MULTIPLE PRICING
There are 6 price fields in the inventory database (INV.DBF) that will
be presented/displayed onto the screen for selection IF you have the multiple
pricing flag 'turned on' (in Configuration) AND any of the price fields
(PRICE1 to PRICE5) have a value not equal to zero...
╔════════════════════════════════════╗
║Select From Multiple Pricing ║
║ 0 to 4: 31.150║
║ 5 to 9: 32.730║
║ 10 to 14: 33.230║
║ 15 to 43: 34.180░
║ 44 to 46: 35.330║
║ More Than 46: 36.200║
╚════════════════════════════════════╝
The PRICEX field in the customer database (CUSTOMER.DBF) will override
the quantity values if it contains a number between 1 and 5. If the PRICEX
field equals 0, then the highlighted price is determined by the quantity
ordered. If the PRICEX field is greater than 6, then the first price (the
default) will always be highlighted.
Read more on multiple pricing in the Configuration section...
DAYO Quotes, TJS LAB Page: 10
■ FINAL QUOTE EDIT SCREEN
When all Quote detail items have been selected, press 'Esc' once to
bring up the final Quote edit screen. It is this screen that gives you the
chance to change the key Quote header information, ie:
Customer Number 1330
Bill To Name Tim Johnson
Edit/Alter Quote Header
Ship To Name Johnson Air Conditioning
Address 1 710 Teays Valley Road
Address 2
City Winfield
State WV
Zip 55555-5555
Phone (800) 555-5555
Type REG
Terms COD
Shipper UPS GROUND
Sales Person TJ
Tax Rate 0.060
Customer PO
Adjustment 0.00
Freight 10.00
Amount Paid 0.00
Taxes 2.04
Detail Subtotal 442.99
Comment Thank You!
Esc (Exit) Enter/Return (Edit/Alter)
To edit any of the header fields (except customer number and Bill To
name), highlight the field, then press Enter/Return. You will be given the
opportunity to edit the field or select from a list of choices.
■ MULTIPLE SHIP TOS
If a customer has multiple Ship To addresses, highlight and press enter
on the Ship To Name and a selection window will appear onto the screen with
all the Ship Tos for that customer.
╔════════════════════════════════════════════════════════════════════════════╗
║ Select the Ship To Address & Data ║
╠════════════════════════════════════════════════════════════════════════════╣
║1 APPLEBERY'S BAR 1234 EASTERN WAY MORGANTOWN, PA 55555-5555 ║
║2 APPLEBERY'S BAR 600 MAJOR BLVD LANSING, PA 55555-5555 ║
║3 APPLEBERY'S BAR 70 LINCOLN ROAD JERSEY, PA 55555-5555 ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO Quotes, TJS LAB Page: 11
The 'Type', 'Terms', 'Shipper', and 'Tax Rate' fields will bring up a
list of only the valid choices, ie:
TYPE: TERMS:
┌─────────────────────────────────────┐ ┌────────────────────┐
│ Select Type │ │ Select Terms │
│REG - REGULAR SALE │ │COD │
│Ret - RETURN │ │CASH │
│Ref - REFUND │ │MASTERCARD │
│SPC - SPECIAL │ │VISA │
│LON - LOANED │ │DISCOVER │
│EXC - EXCHANGE │ │NET 7 │
│TRN - TRANSFER │ │NET 10 │
│VOD - VOIDED │ │NET 15 │
└─────────────────────────────────────┘ │NET 30 │
│NET 60 │
└────────────────────┘
SHIPPER:
┌────────────────────┐
│ Select Shipper │
│DELIVER │ TAXCODE/TAXRATE:
│UPS GROUND │ ┌──────────────────┐
│UPS BLUE │ │ Select Tax Rate │
│UPS RED │ │0 - 0.000 │
│AIRBORNE │ │1 - 0.060 │
│FEDERAL EXPRESS │ │2 - 0.065 │
│TRUCK │ └──────────────────┘
│SPECIAL DELIVERY │
│US MAIL │
│PICKUP │
└────────────────────┘
■ LAST CHANCE TO ABORT QUOTE
When finished with the final Quote screen, press 'Esc'.
The following box will appear onto the screen giving you the option to
Post (continue with) the Quote process, Redo the final Quote screen (maybe
change the terms...), or to just quit (abort!).
╔══════════════════════════════════════╗
║ Order Total: 435.03 ║
║ ║
║ Total Due: 435.03 ║
║ ║
║ Post This Quote? (Y/N/Q) ║
║ ─────────────────────────── ║
║ Y (OK) N (Redo) Q (Quit/Abort) ║
╚══════════════════════════════════════╝
DAYO Quotes, TJS LAB Page: 12
■ PRINTER OFFLINE MESSAGE
If your printer is offline (and attached to LPT1), the following message
will appear onto the center screen. Fix the printer, or press 'Esc' to
abort the printing. Note, you can always print the quote later...
╔════════════════════════════════════════════════════════════════════════╗
║ Your Printer is Not Ready! Please Fix, or Press Esc to Abort! ║
╚════════════════════════════════════════════════════════════════════════╝
■ DATABASE POSTING
Database posting means the updating of all databases affected by the
creation of a Quote. DAYO Quotes post to 2 databases, QUOTES.DBF (header),
and QUOTESD.DBF (detail). The database names are displayed onto the upper
right of the screen as they are updated, ie:
╔═[ Posting Progress ]════╗
║ Quote Header ║
║ Quote Detail ║
╚═════════════════════════╝
■ BROWSE HEADER QUOTE RECORDS
The second QUOTE menu option (BROWSE QUOTE HEADERS) is a browse screen
of all Quote header records. Key information about the customer and the
Quote is printed on the top of the screen, ie:
DAYO Quotes Version 4.0 TJS LAB QUOTE ┌───[February 1992]──┐
╔════════════════════════════════════════════════════════════════════════════╗
║ BILL TO: SHIP TO: ║
║ Salley Morgan Salley Morgan ║
║ Po Box 58 PO BOX 58 ║
║ 1001 Lazy Drive 1001 Lazy Drive ║
║ Morganville, PA 55555-5555 Morganville, PA 55555-5555 ║
║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║
║ 123 REG JD CASH US MAIL ║
║ PHONE ATTN CREDIT LASTDATE ║
║ (800) 555-5555 Norman H. 0.00 12/28/89 ║
╚═══════════════════════[ Browse the Quote Headers ]═════════════════════════╝
QUOTE CUSTOMER SHIPNAME
─────────────────────╥──────────╥─────────────────────────────────────────────
5 ║ 123 ║ TJS LAB
6 ║ 243 ║ ARNEN INDUSTRIES
7 ║ 244 ║ HARPERS FLOWERS
8 ║ 543 ║ JOE'S PIZZA
9 ║ 451 ║ YANKEE CLIPPER
10 ║ 634 ║ ARLIE JAMES
11 ║ 333 ║ JOE MORGAN INC
Esc (Exit) F2 (Edit) F3 (Detail) Ctrl N (Add) Ctrl U (Delete/Recall)
Find: F5 (Invoice) F6 (Ship To Name) F7 (Customer)
DAYO Quotes, TJS LAB Page: 13
■ EDIT HEADER QUOTE RECORDS
Press 'F2' to bring up the full screen edit option. Note, this capability
can be removed with the 'Allow Browse Edit' configuration setting.
Example of a Full Screen Edit of the Quote header record:
DAYO Quotes Version 4.0 TJS LAB QUOTE
┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐
│ QUOTE: 7 FREIGHT: 2.00 │
│ CUSTOMER: 1 SUBTOTAL: 10.00 │
│ SHIPNAME: Salley Morgan OPEN: T │
│ SHIPADDR1: PO BOX 58 PAID: │
│ SHIPADDR2: COMMENT: Thank You! │
│ SHIPCITY: Morganville PRINTED: F │
│ SHIPSTATE: PA │
│ SHIPZIP: 55555-5555 │
│ PHONE: (800) 555-5555 │
│ TYPE: REG │
│ TERMS: COD │
│ SHIPPER: UPS GROUND │
│ DATE: 12/10/89 │
│ TIME: 13:17:31 │
│ REG: │
│ BY: Jose Jargen │
│ SALESPER: SLF │
│ CUST_PO: │
│ TAXRATE: 0.060 │
│ TAXES: 1.32 │
│ ADJUST: 1.00 │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
■ ADD A BLANK QUOTE HEADER RECORD
If so configured ('Allow Browse Edit'), you can add Quote header
records by pressing 'Ctrl N'. Note, this is highly NOT recommended!
■ DELETE QUOTE HEADER RECORD
If so configured ('Allow Browse Edit'), you can mark Quote header
records for deletion by pressing 'Ctrl U'. Use this option to 'clean out'
all unwanted quote header records in the database: QUOTES.DBF. Use the PACK
option in the MISC Routines menu to permanently remove the deleted records.
Be sure to reindex after any PACK!
DAYO Quotes, TJS LAB Page: 14
■ BROWSE DETAIL QUOTE RECORDS
The third QUOTE menu option (BROWSE QUOTE DETAIL) is a browse screen
of all Quote detail records. Key information about the customer is printed
on the top of the screen, ie:
DAYO Quotes Version 4.0 TJS LAB QUOTE
╔════════════════════════════════════════════════════════════════════════════╗
║ BILL TO: SHIP TO: ║
║ Salley Morgan Salley Morgan ║
║ PO Box 58 PO BOX 58 ║
║ 1001 Lazy Drive ║
║ Morganville, PA 55555-5555 Morganville, PA 55555-5555 ║
║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║
║ 1 REG FGH NET 90 TRUCK ║
║ PHONE ATTN TAXRATE LASTDATE ║
║ (800) 555-5555 Salli 0.050 01/23/90 ║
╚═══════════════════════[ Browse the Quote Detail ]══════════════════════════╝
QUOTE ITEM DESC QTY PRICE
────────╥──────────────╥────────────────────────────────╥─────────╥───────────
7 ║ 12343 ║ 20 Bond Paper, Ream ║ 455 ║ 20.00
7 ║ 12444 ║ 18 Bond Paper, Ream ║ 56 ║ 15.66
7 ║ 22344 ║ Cardboard Sheets 8x12 " ║ 55 ║ 4.70
7 ║ 34444 ║ Cardboard Sheets 3x4 " ║ 4 ║ 1.36
7 ║ 37658 ║ Binder, Red #1 ║ 88 ║ 1.36
7 ║ 43466 ║ Binder, Green #1 ║ 61 ║ 1.36
7 ║ 45786 ║ Binder, Red #3 ║ 23 ║ 3.56
7 ║ 75487-3A ║ Loose Leaf Paper, 500 Pack ║ 230 ║ 6.17
8 ║ 950000 ║ Loose Leaf Paper, 100 Pack ║ 2344 ║ 2.10
Esc (Exit)
22/332
Press 'F2' to bring up the full screen edit option. Note, this capability
can be removed with the 'Allow Browse Edit' configuration setting.
Example of a Full Screen Edit of the Quote detail record:
DAYO Quotes Version 4.0 TJS LAB QUOTE
┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐
│ QUOTE: 1200 │
│ ITEM: YOULM-7800 │
│ DESC: CHAIN SAW, 98" BLADE │
│ QTY: 10 │
│ PRICE: 1293.70 │
│ COST: 893.63 │
│ TAXABLE: T │
│ DATE: 12/27/89 │
│ │
│ │
DAYO Quotes, TJS LAB Page: 15
■ ADD A BLANK QUOTE DETAIL RECORD
If so configured ('Allow Browse Edit'), you can add Quote detail
records by pressing 'Ctrl N'. Note, this is highly NOT recommended!
■ DELETE QUOTE DETAIL RECORD
If so configured ('Allow Browse Edit'), you can mark Quote detail
records for deletion by pressing 'Ctrl U'. Use this option to remove unwanted
records from the QUOTESD.DBF. Remove deleted records with the PACK option
in the MISC Routines menu. Be sure to reindex after the PACK!
■ TEMPLATES
'Templates' is the DAYO term for a collection of detail line items
that can be easily added to a Quote. Templates can be created to contain
a set of items that in turn create a bundle, 'bill of material', or just a
group of commonly sold items.
Creating templates is accomplished by selecting the fourth QUOTE menu
option ('BROWSE/CREATE TEMPLATE'). The TEMPLATE browse screen contains a
box atop the page with all the key item information. The lower part of the
screen is just your normal DAYO browse screen.
DAYO Quotes Version 4.0 TJS LAB QUOTE
╔═════════════════════════════════════════[ Item Info ]══════════════════════╗
║ Item Vendor Item Vendor Description Type ║
║ DAYOPOS-M DAYOPOS-M TJS Manual, DAYO POS MAN ║
║ Onhand OnOrder Cost Retail Price Template Price ║
║ 22 1 5.00 5.00 5.00 5.00 ║
╚════════════════════════[ Browse/Create Templates ]═════════════════════════╝
TEMPLATE ITEM DESC QTY
───────────────╥──────────────╥────────────────────────────────╥──────────────
4 ║ DAYOPOS-M ║ Manual, DAYO POS ║ 1
4 ║ DAYOQUO-M ║ Manual, DAYO Quotes ║ 1
4 ║ DAYOPB-M ║ Manual, DAYO Price Book ║ 1
5 ║ DAYOX-SL ║ DAYO Index, Source License ║ 1
5 ║ DAYOINV-SL ║ DAYO Inventory, Source License ║ 1
5 ║ DAYOPOS-SL ║ DAYO POS, Source License ║ 1
5 ║ DAYOAR-SL ║ DAYO AR, Source License ║ 1
6 ║ DAYOUTIL-SL ║ DAYO UTILITIES, Source License ║ 1
║ ║ ║
Esc (Exit/Abort) F1 (Help) F2 (Edit) F3 (Add Item From Inventory)
Ctrl N (Add/Create New Template) Ctrl U (Delete/Recall)
Find: F5 (Template)
DAYO Quotes, TJS LAB Page: 16
Press 'F2' to bring up the Full Screen Edit screen, ie:
DAYO Quotes Version 4.0 TJS LAB QUOTE
┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐
│ TEMPLATE: 0 │
│ ITEM: 199900 │
│ DESC: BIG JAR │
│ QTY: 23 │
│ PRICE: 23.40 │
│ DATE: 12/12/89 │
│ │
To add an item to the template, press 'F3'. This brings up a browse
selection screen of the inventory (below). Find the item you wish to add to
the current template, then press Enter/Return.
DAYO Quotes Version 4.0 TJS LAB QUOTE
╔═════════════════════════════════════════[ Item Info ]══════════════════════╗
║ Item Vendor Item Vendor Description Type ║
║ ABC-12312 ABC-12312 ABC SOFA, GROMMAN STYLE, BROWN SOF ║
║ Onhand OnOrder Cost Retail Price Template Price ║
║ 12 100 145.00 565.00 235.00 199.00 ║
╚═════════════════════[ Select Item From The Inventory ]═════════════════════╝
ITEM DESC ONHAND ONORDER BO
──────────────╥────────────────────────────────╥─────────╥─────────╥──────────
ABC-12312 ║ SOFA, GROMMAN STYLE, BROWN ║ 12 ║ 100 ║ 0
ABC-12324 ║ SOFA, GREEN ║ 23 ║ 0 ║ 0
ABC-12343 ║ SOFA, TYPE 2 ║ 23 ║ 25 ║ 0
ABC-12345 ║ SOFA, NEW YORKER ║ 30 ║ 0 ║ 0
ABC-12354 ║ SOFA, WICKER ║ 60 ║ 35 ║ 0
ABC-12365 ║ SOFA, SMALL WICKER ║ 64 ║ 2 ║ 0
ABC-12371 ║ SOFA, SMALL WICKER, (USED) ║ 15 ║ 5 ║ 0
ABC-12399 ║ SOFA, MISC ║ 44 ║ 5 ║ 0
ABC-123A1 ║ SOFA, CHAIR (1/2 SIZE) ║ 18 ║ 25 ║ 0
ABC-123A1 ║ SOFA, ARMLESS, RED BROWN ║ 54 ║ 0 ║ 0
ABC-123A1 ║ CHAIR, PLAIN ║ 45 ║ 0 ║ 0
ABC-123A1 ║ CHAIN, KITCHEN PADDED TAN ║ 0 ║ 34 ║ 0
ABC-123A1 ║ CHAIR, KITCHEN PADDED GREEN ║ 35 ║ 0 ║ 0
Esc (Exit/Abort) Enter/Return (Select Item)
Find: F5 (Item) F6 (Desc) F7 (Vendor) F8 (Vendor Item) F9 (Type)
70/74
DAYO Quotes, TJS LAB Page: 17
■ CREATE NEW TEMPLATE
Press 'Ctrl N' to create a new template number. A default template number
is determined by going to the bottom of the file and adding '1' to that
template number. You will be prompted to change or accept the new template
number, ie:
┌────────────────────────────────────────────────────────────────────────────┐
│ Enter Template Number: 4 │
└────────────────────────────────────────────────────────────────────────────┘
After this point, the adding of the template line items is the same as
described above (using the F3 key)...
■ DELETE TEMPLATE ITEM
To delete a template line item, press 'Ctrl U'. Use the MISC ROUTINES
module to PACK the TEMPLATE DATABASE. BE SURE TO REINDEX THE TEMPLATE INDEX
(TEMPLATE.NTX)!
■ REPRINT A QUOTE
Reprinting a Quote is accomplished via the fifth QUOTE menu option
(REPRINT QUOTE). The REPRINT QUOTE screen is a browse screen of all Quote
header records. The important quote and customer data is displayed atop
the screen, ie:
DAYO Quotes Version 4.0 TJS LAB QUOTE
╔════════════════════════════════════════════════════════════════════════════╗
║ BILL TO: SHIP TO: ║
║ MORGAN SCOTT MORGAN SCOTT WAREHOUSE #5 ║
║ 1929 LAKE CITY ROAD 8000 EAST STREET ║
║ CANTON, OH 23433 HARTFORD, CT 23493-2333 ║
║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║
║ 2333 A DSG NET 36 UPS BLUE ║
║ PHONE ATTN CREDIT LASTDATE ║
║ (237) 333-5555 Harold Keith 394.56 12/29/89 ║
╚═══════════════════════════[ Reprint A Quote ]══════════════════════════════╝
QUOTE CUSTOMER SHIPNAME
─────────────────────╥──────────╥─────────────────────────────────────────────
2341 ║ 27400 ║ MARTINS NURSERY
2342 ║ 25423 ║ JULIE BROWN
2343 ║ 23323 ║ JULIE BROWN, INC
2344 ║ 28434 ║ HARPERS FERRY BOAT
2345 ║ 2333 ║ MORGAN SCOTT
2348 ║ 21188 ║ COMPU AIDE
Esc (Exit/Abort) Enter/Return (Select Invoice For Reprint)
Find: F5 (Invoice) F6 (Ship To Name) F7 (Customer)
* * * Find the Quote you want reprinted, then press Enter/Return.
DAYO Quotes, TJS LAB Page: 18
■ CUSTOMERS
The customer maintenance routine for DAYO Quotes is not a very elaborate
one, nor was meant to be. Use this option to view (only), your customer data.
The CUSTOMERS option consists of a typical DAYO browse screen of all
customers. Key customer information is printed on the top half of the screen,
the browse at the lower half, ie:
DAYO Quotes Version 4.0 TJS LAB CUSTOMER
╔════════════════════════════════════════════════════════════════════════════╗
║ BILL TO: SHIP TO: ║
║ DIRK HARPER WAREHOUSE 3 ║
║ 3900 LEFTY ROAD ║
║ ║
║ ORLANDO, FL HINESVILLE, GA 31313 ║
║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║
║ 687 REG DD NET 60 UPS RED ║
║ PHONE ATTN TAXRATE LASTDATE ║
║ 912 767-5555 MOHAMMED 0.550 12/29/89 ║
╚════════════════[ Browse the Customer Database (View Only) ]════════════════╝
CUSTOMER NAME ATTN
───────────╥────────────────────────────────╥─────────────────────────────────
687 ║ DIRK HARPER ║ MOHAMMED
2344 ║ DON JUAN PRODUCTIONS ║
2356 ║ UNIVERSAL INC ║
2365 ║ HAPPY FLOWERS BOUTIQUE ║ JOE
3457 ║ ARGON DEVELOPERS ║
3465 ║ ARGON, INC ║ GEORGE
3477 ║ BILLY ARGON ║ ARLIE
3478 ║ MARY ELIZABETH COSMETICS ║ TRACIE MORGAN
Esc (Exit) F1 (Help)
Find: F5 (Customer) F6 (Name) F7 (Ship To) F8 (Phone) F9 (Zip Code)
■ CONFIGURATION
DAYO Quotes configuration contains many configurable options that will
hopefully make DAYO Quotes better able to meet your specific needs. There are
30+ significant DAYO Quotes configuration settings:
Company Name Default Terms
Company Address Inventory Location
Company Telephone Customer Location
Auto Print Quote POS Location
Last Quote Number Price Book Location
Quote Printer Type Report Printer Type
Quote Printer Port Report Printer Port
Quote Copies Visual Indexing
Default Tax Code Auto Daily Indexing
Default Quote Type Color
Allow Browse Edit High Intensity
Default Shipper Allow Customer Add
Tax Adjustments Tax Freight
Show Cost on Screen Default Freight %
Multiple Prices Use 2nd Tax
DAYO Quotes, TJS LAB Page: 19
Before creating any Quote, it is highly recommended that you read this
section to get a better understanding of the meanings of every configuration
setting. After determining how you wish to set/run DAYO Quotes, make the
changes.
■ CONFIGURATION DEFAULT SETTINGS
The default values for key configuration settings are listed below:
Company Name YOUR COMPANY, INC
Company Address Attn: Accounts Receivable
P.O. Box 5555
ANYCITY, ST 55555-5555
Company Telephone 800-555-5555
Auto Print Quote YES
Last Quote Number 0
Quote Printer Type STANDARD
Quote Printer Port LPT1
Quote Copies 1
Default Tax Code 1
Default Quote Type REG
Allow Browse Edit YES
Default Shipper PICKUP
Default Terms CASH
Inventory Location 'Current Directory'
Customer Location 'Current Directory'
POS Location 'Current Directory'
Price Book Location 'Current Directory'
Report Printer Type STANDARD
Report Printer Port LPT1
Visual Indexing YES
Auto Daily Indexing YES
Color YES
High Intensity NO
DAYO Quotes, TJS LAB Page: 20
■ CONFIGURATION MENU
The CONFIGURATION menu is a selection box that appears on the left side
of the main menu screen, ie:
DAYO Quotes Version 4.0 TJS LAB CONFIG ┌───[February 1992]──┐
╔════════════════════════╗ │S M T W T F S │
║ CONFIGURATION ║ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤
╟────────────────────────╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6│
║ Company Name ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 7 8 9 10 11 12 13│
║ Company Address ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │14 15 16 17 18 19 20│
║ Company Telephone ║ █░ █░ █░ █░ █░ █░ █░ │21 22 23 24 25 26 27│
║ Auto Print Quote ║ ████▀ █░ █░ █░ ▀███▀ │28 29 30 31 │
║ Last Quote Number ║ │ │
║ Quote Printer Type ║ └────────────────────┘
║ Quote Printer Port ║ ╓────────────────────────────────────────────────╖
║ Quote Copies ║ ║ DAYO QUOTES STATISTICS ║
║ Default Tax Code ║ ║ DATABASE NAME RECORDS SIZE ║
║ Default Quote Type ║ ║ INV.DBF Inventory 1 1K ║
║ Allow Browse Edit ║ ║ QUOTE.DBF Quote Header 10 5K ║
║ Default Shipper ║ ║ QUOTESD.DBF Quote Detail 69 6K ║
║ Default Terms ║ ║ CUSTOMER.DBF Customers 18 9K ║
║ Inventory Location ║ ╚════════════════════════════════════════════════╝
║ Customer Location ║███▄ ████▄ ▄██▄
║ POS Location ║█░ █░ █░
║ Price Book Location ║█░ █▄▄▄ ▀██▄
║ Report Printer Type ║█░ █░ █░
╟────────────────────────╢█░ ████▀ ▀██▀
║ Select Option ║
╚════════════════════════╝
To access any of the options (you can scroll down to others), highlight
the option, then press Enter/Return.
■ COMPANY NAME, ADDRESS & TELEPHONE
Each field for these options is limited to 30 characters, 14 for the
telephone...
┌──────────────────────────────[ COMPANY NAME ]─────────────────────────────┐
│ Enter Your Company Name: YOUR COMPANY NAME HERE │
└───────────────────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: 21
┌─────────────────────────────[ COMPANY ADDRESS ]───────────────────────────┐
│ Address Line 1: Attn: Accounts Receivable │
│ Address Line 2: P.O. BOX 555555 │
│ City, State ZIP: ANYCITY, ST 55555-5555 │
└───────────────────────────────────────────────────────────────────────────┘
┌────────────────────────────[ COMPANY TELEPHONE ]──────────────────────────┐
│ Enter Your Company Telephone: 800-555-5555 │
└───────────────────────────────────────────────────────────────────────────┘
■ AUTOMATICALLY PRINT THE QUOTE
┌───────────────────────[ AUTOMATICALLY PRINT QUOTES ]───────────────────────┐
│ If you want your quotes to automatically print their creation, then │
│ change this option to Y (YES). │
│ Default is to automatically print the quotes. │
│ │
│ Automatically Print Quotes? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ LAST QUOTE NUMBER
┌───────────────────────────[ LAST QUOTE NUMBER ]────────────────────────────┐
│ Enter Last Quote Number: 0 │
└────────────────────────────────────────────────────────────────────────────┘
■ QUOTE PRINTER TYPE
┌───────────────────────────[ QUOTE PRINTER TYPE ]───────────────────────────┐
│ There are 3 types of DAYO printed quotes: STANDARD, LASER, and the │
│ DATA ONLY quotes. │
│ The STANDARD quote prints standard characters with headings. │
│ The LASER quote prints a special quote onto a Hewlett Packard (tm) │
│ compatible laser printer. │
│ The DATA ONLY quote is the same as the STANDARD with the exception │
│ of the headings (for use with pre-printed forms). │
│ │
│ Enter Your Quote Printer Type -> STANDARD │
│ LASER │
│ DATA ONLY │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: 22
■ QUOTE PRINTER PORT
┌───────────────────────────[ QUOTE PRINTER PORT ]───────────────────────────┐
│ Enter Your Quote Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ QUOTE COPIES
┌────────────────────[ Number of Quote Copies To Print ]─────────────────────┐
│ This option determines the number of quote copies to print at the │
│ time of printing. Default is to print one copy of the quote. │
│ │
│ Enter Number of Quote Copies: 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ DEFAULT TAX CODE
┌────────────────────────────[ DEFAULT TAX CODE ]────────────────────────────┐
│ This Tax Code/Rate will be the percentage of tax withheld on all │
│ taxable customer quotes. These Tax Codes/Rates are maintained in │
│ the tax code database (TAXCODE.DBF). Use the BROWSE DATABASE option in │
│ the MISC Routines to add/change/delete the records in this database. │
│ │
│ Select The Default Tax Code/Rate -> 0 - 0.000 │
│ 1 - 0.060 │
│ 2 - 0.065 │
└────────────────────────────────────────────────────────────────────────────┘
*** If you need additional decimals, read about the 'fix' in the QUIRKS
section near the end of this document...
■ DEFAULT QUOTE TYPE
┌───────────────────────────[ DEFAULT QUOTE TYPE ]───────────────────────────┐
│ The Quote Type is used to differentiate between types of Quotes/Invoices │
│ For example, type REG would be for regular sales, Ret for returns, │
│ and type VOD for voided invoices. The Quote Types are maintained in │
│ the Types database (TYPE.DBF). Use the BROWSE DATABASE option in │
│ the MISC Routines to add/change/delete the records in this database. │
│ │
│ Select The Default Quote Type -> REG - REGULAR SALE │
│ Ret - RETURN of item (and refund) │
│ Ref - REFUND │
│ SPC - SPECIAL *** │
│ LON - LOANED │
│ EXC - EXCHANGE │
│ TRN - TRANSFER │
│ VOD - VOIDED │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: 23
■ ALLOW BROWSE EDITING
┌─────────────────────────[ ALLOW BROWSE EDITING ]───────────────────────────┐
│ To disable the editing of the Quote Header/Detail Records, │
│ select N (NO) to this option. Default is to allow it. │
│ │
│ Allow Editing of Quote Header/Detail Records? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ DEFAULT TERMS
┌─────────────────────────────[ DEFAULT TERMS ]──────────────────────────────┐
│ This selection is used on new Quotes if the Customers TERMS │
│ can not be determined. TERMS are maintained in the terms database │
│ (TERMS.DBF). Use the BROWSE DATABASE option in the MISC Routines to │
│ add/change/delete the records in this database. │
│ │
│ Select The Default Terms -> CASH │
│ CHECK │
│ COD │
│ AMERICAN EXPRESS │
│ MASTERCARD │
│ VISA │
│ DISCOVER │
│ NET 7 │
│ NET 10 │
│ NET 15 │
└────────────────────────────────────────────────────────────────────────────┘
■ DEFAULT SHIPPER/METHOD OF SHIPMENT
┌───────────────────[ DEFAULT SHIPPER/METHOD OF SHIPMENT ]───────────────────┐
│ This selection is used on new Quotes if the Customers SHIPPER/ │
│ METHOD OF SHIPMENT can not be determined. SHIPPERS/METHOD OF SHIPMENT │
│ selections are maintained in the shipper database (SHIPPER.DBF). │
│ Use the BROWSE DATABASE option in the MISC Routines to add/change/delete │
│ the records in this database. │
│ │
│ Select The Default Shipper -> PICKUP │
│ DELIVER │
│ UPS GROUND │
│ UPS BLUE │
│ UPS RED │
│ AIRBORNE │
│ FEDERAL EXPRESS │
│ TRUCK │
│ SPECIAL DELIVERY │
│ MODEM │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: 24
■ INVENTORY DATABASE LOCATION/DIRECTORY
┌──────────────────────[ INVENTORY LOCATION/DIRECTORY ]──────────────────────┐
│ The location of the DAYO Inventory (INV.DBF) does not have to be in │
│ the same drive/directory as DAYO Quotes. If you have installed DAYO │
│ Inventory into a different directory, you need to tell DAYO Quotes where │
│ to find the inventory database (INV.DBF). Default is nil (current │
│ directory). Be sure to include the rightmost slash, ie: \DAYOINV\ │
│ The drive designation is optional (if same as DAYO Quotes). │
│ │
│ Enter Location: \DAYOINV\ │
└────────────────────────────────────────────────────────────────────────────┘
■ CUSTOMER DATABASE LOCATION/DIRECTORY
┌──────────────────[ CUSTOMER DATABASE LOCATION/DIRECTORY ]──────────────────┐
│ The location of the DAYO Customer file (CUSTOMER.DBF) does not have to be │
│ in the same drive/directory as DAYO Quotes. If you have installed the DAYO │
│ Customer Database (CUSTOMER.DBF), into a different directory, you need │
│ to tell DAYO Quotes where to find it. Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYOAR\ │
│ The drive designation is optional (if same as DAYO Quotes). │
│ │
│ Enter Location: \DAYOAR\ │
└────────────────────────────────────────────────────────────────────────────┘
■ POS DATABASES LOCATION/DIRECTORY
┌─────────────────[ DAYO POS DATABASES LOCATION/DIRECTORY ]──────────────────┐
│ If you have installed DAYO POS into a different drive/directory │
│ than DAYO Quotes, you should enter the location of the POS databases: │
│ TERMS.DBF, TYPE.DBF, TAXCODE.DBF, SHIPPER.DBF, & TEMPLATE.DBF. │
│ Default is the current drive/directory (nil). │
│ Be sure to include the rightmost slash, ie: \DAYOPOS\ │
│ The drive designation is optional (if same as DAYO QUO). │
│ │
│ Enter Location: \DAYOPOS\ │
└────────────────────────────────────────────────────────────────────────────┘
■ PRICE BOOK DATABASE LOCATION/DIRECTORY
┌──────────────[ DAYO PRICE BOOK DATABASE LOCATION/DIRECTORY ]───────────────┐
│ If you have installed DAYO Price Books into a different drive/directory │
│ than DAYO Quotes, you should enter the location of the database: PB.DBF │
│ Default is the current drive/directory (nil). │
│ Be sure to include the rightmost slash, ie: \DAYOPB\ │
│ The drive designation is optional (if same as DAYO QUO). │
│ │
│ Enter Location: \DAYOPB\ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: 25
■ REPORT PRINTER TYPE
┌──────────────────────────[ REPORT PRINTER TYPE ]───────────────────────────┐
│ Routine reports are printed according to this selection. │
│ The STANDARD printer type is a Epson/IBM Proprinter printer. │
│ The LASER printer type is a Hewlett Packard (tm) Laser compatible printer│
│ Special Laser codes are sent to the LASER option. │
│ │
│ Enter Your Report Printer Type -> STANDARD │
│ LASER │
└────────────────────────────────────────────────────────────────────────────┘
■ REPORT PRINTER PORT
┌──────────────────────────[ REPORT PRINTER PORT ]───────────────────────────┐
│ Enter Your Report Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ VISUAL INDEXING
┌────────────────────────────[ VISUAL INDEXING ]─────────────────────────────┐
│ If you desire to see a progress graph each time your indexes are │
│ created, then select Y (YES). Note, the process can slow the indexing │
│ routine down; especially with larger databases. │
│ │
│ Do you wish to have Visual Indexing? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
Example of a 'visual' index:
┌──────────────────────────────────────────────────────────┐
│ Database Name: QUOTESD.DBF │
│ Index Name: QUOITEM.NTX │
│ Number of Records: 69 │
│ ┌──────────────────────────────────────────────────┐ │
│ │███████████████████████████ │ │
│ └──────────────────────────────────────────────────┘ │
│ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │
└──────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: 26
■ TAX THE ADJUSTMENT FIELD ON THE INVOICE
┌────────────────[ TAX THE ADJUSTMENT FIELD ON THE INVOICE ]─────────────────┐
│ This option determines if the field ADJUST (Adjustments) will be used in │
│ the computation of taxes on invoices. │
│ Default is N (No) -> do not tax ADJUSTMENTS... │
│ │
│ Do you wish to tax ADJUSTMENTS? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ DEFAULT FREIGHT PERCENTAGE
┌───────────────────────[ DEFAULT FREIGHT PERCENTAGE ]───────────────────────┐
│ This percentage value determines/calculates a default freight amount for │
│ every new invoice. Default is 0%; to enter the freight amount. │
│ Example: 4% would be entered as '0.0400' │
│ │
│ Enter Default Freight Percentage: 000.040 │
└────────────────────────────────────────────────────────────────────────────┘
■ TAX THE FREIGHT FIELD ON THE INVOICE
┌──────────────────[ TAX THE FREIGHT FIELD ON THE INVOICE ]──────────────────┐
│ This option determines if the field FREIGHT will be used in │
│ the computation of taxes on invoices. │
│ Default is N (No) -> do not tax FREIGHT... │
│ │
│ Do you wish to tax FREIGHT? (Y/N) │
│ │
│ You can specify specific states (based on SHIPSTATE), or just leave │
│ blank to tax freight for all customers in all states... │
│ Separate valid state codes with a comma, ie: 'SC,NC,GA,CA' │
│ Default is to tax freight for all SHIP TO STATES. │
│ │
│ Enter Specific SHIPSTATEs: FL,GA,NC │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: 27
■ USE MULTIPLE PRICES - MULTIPLE PRICE TABLES
┌──────────────[ USE MULTIPLE PRICES - MULTIPLE PRICE TABLES ]───────────────┐
│ If your inventory databases has multiple prices (PRICE1 -> PRICE5), and │
│ you wish to have the option to select from them at time of invoicing, │
│ then select Y (Yes) to this option. Default is Y (Yes)... │
│ If this option is set to Y (Yes), you are given the option to edit │
│ the Multiple Price Tables which determines which of the PRICEx fields │
│ will be the default based on the number of items ordered (ie: you give │
│ your customers discounts for buying more than 1 item...) │
│ * Use the 'SET PRICEx' routine in Smart Reports to place values in the │
│ PRICEx fields (in the inventory database). │
│ │
│ Use Multiple Pricing? (Y/N) │
│ │
│ Input the limits (eXclusive) for each of the Price fields. │
│ * Any quantities greater to or equal to the PRICE4 quantity will take │
│ the PRICE5 price as the default... │
│ │
│ PRICE PRICE1 PRICE2 PRICE3 PRICE4 │
│ 5 10 15 44 47 │
└────────────────────────────────────────────────────────────────────────────┘
■ USE 2ND TAX
In addition to the prompts below, the option to select the 2nd tax
title/heading exists.
Note, the amount in the 11th and 12th options is specified by you.
┌──────────────────────────────[ USE 2ND TAX ]───────────────────────────────┐
│ If you have 2 taxes to be recorded at time of invoice, then select │
│ Y (YES), else select N (NO) for single or no taxes. │
│ The default is NOT to prompt/use a second tax. │
│ 2nd Tax Current Setting: Tax Subtotal + Adjustments + Freight + 1st Tax │
│ │
│ Do you wish to maintain a second tax? (Y/N) │
│ │
│ Select Option -> Tax Subtotal Only │
│ Tax Freight Only │
│ Tax Adjustments Only │
│ Tax Subtotal + 1st Tax │
│ Tax Subtotal + Adjustments │
│ Tax Subtotal + Adjustments + 1st Tax │
│ Tax Subtotal + Freight │
│ Tax Subtotal + Freight + 1st Tax │
│ Tax Subtotal + Adjustments + Freight │
│ Tax Subtotal + Adjustments + Freight + 1st Tax │
│ Tax Subtotal Up To $5000.00 │
│ Tax Subtotal After $5000.00 │
│ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: 28
■ AUTOMATIC DAILY INDEXING
┌────────────────────────[ AUTOMATIC DAILY INDEXING ]────────────────────────┐
│ If this option is set to Y (YES), then all DAYO Indexes accessed by │
│ DAYO Quotes will be recreated once daily. This will occur when the first │
│ DAYO Quotes program is run. The default is to recreate all the indexes. │
│ │
│ Recreate all DAYO Quotes Indexes? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ COLOR MONITOR
┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐
│ If you have a color monitor and wish to display colors, then select Y, │
│ (YES), else select N (NO) for monochrome and others. The default is │
│ color, low intensity. Note, you must exit, then reenter the program to │
│ activate a color and/or intensity change. │
│ │
│ Do you have a color monitor? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ COLOR INTENSITY
┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐
│ Intensity is only applicable with color set to Y. │
│ It will make your colors brighter... │
│ │
│ Set Color Intensity On? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: 29
■ REPORTS
The REPORTS menu contains 6 reports, many with different options and a
printer setup/driver routine. Note that other reports can be created using
dBase III+/IV (tm) as well as other compatible report writers. The MISC
Routines even has the LIST function in it that allows the creation of simple
lists/reports...
The Reports menu:
╔═════════════════════════════╗
║ DAYO QUOTES REPORTS ║
║ Quotes Header Reports ║
║ Quotes Detail Reports ║
║ Customer Address Labels ║
║ Templates All ║
║ Database Status ║
║ Config Status ║
║ Printer Setup ║
║ SELECT REPORT ║
╚═════════════════════════════╝
The Quotes Header, Detail, and the Template Reports are a collection of
'report forms'. These report forms all have the extension of '.FRM', and are
dBase (tm) compatible.
Report Form Uses
Name Database
────────────── ───────────────
TEMPLATE.FRM TEMPLATE.DBF
QUOTES.FRM QUOTES.DBF
QSALESP.FRM "
QUOCUST.FRM "
QUOTESD.FRM QUOTESD.DBF & QUOTES.DBF & CUSTOMER.DBF
QDITEM.FRM " " "
QDVEND.FRM " " "
QDSALP.FRM " " "
QDCUST.FRM " " "
DAYO Quotes, TJS LAB Page: 30
■ QUOTES HEADER REPORTS
Quotes Header Reports are printouts (to paper or disk file) of records in
the database QUOTES.DBF. There are 3 Quotes Header Report types, each with
its own index and report form, ie:
Report Name Indexed on Report Form Name
─────────────────── ───────────── ─────────────────
Sales Person SALESPER QSALESP.FRM
Customer Number CUSTOMER QUOCUST.FRM
Quote Number QUOTE QUOTES.FRM
The Quotes Header Reports selection box:
╔═══════════════════════════════════════════════════════╗
║The Quotes Header Reports derive their data from the ║
║database: QUOTES.DBF. ║
║Creation of a temporary index is required for the ║
║Sales Person Report. ║
║ ║
║Select Report -> Customer Number ║
║ ║
║Print All? (Y/N) ║
║( N -> prompts for specific Customer Number ) ║
║ ║
║ ║
║ ║
║Start Date: 01/06/90 Ending Date: 01/06/90 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║Enter File Name: InvCust.TXT ║
║ ║
║Enter Report Title: TJS LAB ║
╚═══════════════════════════════════════════════════════╝
■ QUOTES DETAIL REPORTS
Quotes Detail Reports are printouts (to paper or disk file) of records in
the database QUOTESD.DBF. The QUOTES.DBF and the CUSTOMER.DBF are also used
in the creation of Quotes Detail Reports. There are 5 Quotes Detail Report
types, each with its own index and report form, ie:
Report Name Indexed on Report Form Name
─────────────────── ───────────── ─────────────────
Quote QUOTE QUOTESD.FRM
Item ITEM QUOITEM.FRM
Vendor Item VENDITEM QUOVEND.FRM
Sales Person SALESPER QUOSALP.FRM
Customer CUSTOMER QUOCUST.FRM
DAYO Quotes, TJS LAB Page: 31
The Quotes Detail Reports selection box:
╔═══════════════════════════════════════════════════════╗
║The Quotes Detail Reports derive their data from ║
║the databases: QUOTES.DBF, QUOTESD.DBF, and ║
║INV.DBF. Creation of a temporary index is ║
║required for all but the Quote and Item Reports. ║
║ ║
║Select Report -> Quote ║
║ ║
║Print All? (Y/N) ║
║( N -> prompts for specific Quote Number ) ║
║ ║
║Enter Quote Number: 1 ║
║ ║
║Start Date: 01/06/90 Ending Date: 01/06/90 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║Enter File Name: Quote.TXT ║
║ ║
║Enter Report Title: TJS LAB ║
╚═══════════════════════════════════════════════════════╝
■ CUSTOMER BILL TO ADDRESS LABELS
This report option prints out labels containing the Bill To address of
the customer/client. Find the customer/client you want to create a label for,
then press Enter/Return. Press Enter/Return for as many labels you desire.
To assist you in locating a customer/client, the FIND function keys F5, F6,
F7, and F8 are available.
╔═══════════════════════════════════════════════════════╗
║Use this option to print the Customer BILL TO address ║
║Labels. The Address Label is the standard size of ║
║ 3.5x15/16, 6LPI, and contains the following fields: ║
║ NAME ADDR1 ADDR2 ║
║ CITY STATE ZIP ║
║ ║
║ ┌──────────────────────────────┐ ║
║ │HERMAN GETTINGS │ ║
║ │3939 EASTER LANE │ ║
║ │PO BOX 23993 │ ║
║ │TAMPA, FL │ ║
║ │33618 │ ║
║ ╘══════════════════════════════╛ ║
║ CUSTOMER ║
║Select Customer -> 12237 ║
║ 12238 ║
║ 12239 ║
║ 12240 ║
║Esc (Exit) Enter/Return (Print) F5/F6/F7/F8 (Find) ║
╚═══════════════════════════════════════════════════════╝
DAYO Quotes, TJS LAB Page: 32
■ TEMPLATES ALL REPORT
This report prints the entire contents of the database: TEMPLATE.DBF out
to either the printer or to a disk file. No other option is given. It uses
the report form: TEMPLATE.DBF.
╔═══════════════════════════════════════════════════════╗
║The Template Reports print all template records indexed║
║by the template number. Templates are maintained in the║
║database: TEMPLATE.DBF. ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║Enter File Name: TEMPLATE.TXT ║
╚═══════════════════════════════════════════════════════╝
■ DATABASE STATUS REPORT
This report prints out the structure, number of records and sizes of
all major DAYO Quotes databases. This report does not use a report form. Like
the TEMPLATE Report, this one only gives you the option to print to the
printer or to a disk file, ie:
╔═══════════════════════════════════════════════════════╗
║The Database Summary Report lists the DAYO QUOTES ║
║databases with their current fields, sizes and number ║
║of records. Index files included. Not a Report Form. ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
An example of a Database Status Report follows on the next page. Note,
only one database is listed (there are more!):
DAYO Quotes, TJS LAB Page: 33
++++++++++++++++++++++++
+ DAYO DATABASE REPORT +
++++++++++++++++++++++++
12/28/89
22:14:39
Inventory Database: \dayoinv\INV.DBF
Number of Records: 74
File Size: 13,138
FIELD NAME TYPE LENGTH DECIMALS
============ ==== ====== ========
ITEM C 12 0
DESC C 30 0
ONHAND N 7 0
ONORDER N 7 0
SOLDPTD N 7 0
SOLDYTD N 7 0
VENDITEM C 12 0
VENDOR C 10 0
DATE D 8 0
LASTDATE D 8 0
COST N 10 2
RETAIL N 10 2
PRICE N 10 2
STOCKLEVEL N 7 0
TYPE C 3 0
CLASS C 3 0
TAXABLE L 1 0
SERIALNO L 1 0
WEIGHT N 8 2
UNIT C 3 0
LOCATION C 3 0
======
167
Index Files: INV.NTX Index Key: ITEM
DESC.NTX Index Key: DESC
VENDOR.NTX Index Key: VENDOR
VENDITEM.NTX Index Key: VENDITEM
TYPE.NTX Index Key: TYPE
DAYO Quotes, TJS LAB Page: 34
■ CONFIGURATION STATUS REPORT
The Configuration Status Report is just a list of the current Quotes
configuration settings. It is not a report form. The only option is to print
it to a printer or to a disk file, ie:
╔═══════════════════════════════════════════════════════╗
║The Configuration Status Settings Report lists all of ║
║configuration settings (found in file DAYOQUO.CFG). ║
║This is Not a Report Form. ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║ ║
╚═══════════════════════════════════════════════════════╝
Example of the Configuration Status Settings Report:
++++++++++++++++++++++++++++++++++++
+ DAYO QUOTES CONFIGURATION REPORT +
++++++++++++++++++++++++++++++++++++
01/06/90
16:48:25
Company Name: YOUR COMPANY NAME HERE
Address Line 1: Attn: Sales
Address Line 2: P.O. BOX 55555
City, State Zip: ANYCITY, ST 55555-5555
Telephone: 800-555-5555
Auto Print Quote: Yes
Number of Quote Copies: 1
Last Quote Number: 0
Quote Printer Type: STANDARD
Quote Printer Port: LPT1
Default Quote Type: REG
Default Shipper/Shipment: PICKUP
Default Terms: CASH
Default Tax Code: 1
Default Price Book Margin: 1
Inventory Database Location:
Customer Database Location:
DAYO POS Database Location:
DAYO PB Database Location:
Allow Editing In Browse: Yes
Automatically Reindex Daily: Yes
Report Printer Type: LASER PRINTER
Report Printer Port: LPT1
Visual Indexing: Yes
Color: Yes
High Intensity: No
DAYO Quotes, TJS LAB Page: 35
■ PRINTER DRIVER (SETUP)
This routine was added to preclude you from having to get out of your
seat to change (mess with) the printer to get it to print correctly.
The most important printer selections (ie: font size, lines per inch,
orientation, ...) are made easy to evoke.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
║ ║
║ Select Option -> Eject ║
║ Line feed ║
║ Normal Size ║
║ Use this routine to set your Small/Condensed ║
║ printer up with one or more Bold On ║
║ of the setup strings and Bold Off ║
║ commands listed to the right. 6 Lines per Inch ║
║ 8 Lines per Inch ║
║ Select the 'Change Printer Print Landscape (Laser Only) ║
║ Default' option to change Print Portrait (Laser Only) ║
║ printer types. Reset Printer ║
║ Current printer is set to: Print Special String 1 ║
║ Okidata Print Special String 2 ║
║ Print Special String 3 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
■ PRINTER DRIVER OPTIONS
There are 18 printer driver options to select from. The last option is
to set the default printer, and the next to last is a 'SHELL' function that
runs a DOS command or program. The remainder are strings/codes that are sent
to the printer.
Eject Print Portrait (Laser Only)
Line feed Reset Printer
Normal Size Print Special String 1
Small/Condensed Print Special String 2
Bold On Print Special String 3
Bold Off Print Special String 4
6 Lines per Inch Print Special String 5
8 Lines per Inch Run DOS Command/Program
Print Landscape (Laser Only) Change Default Printer
DAYO Quotes, TJS LAB Page: 36
■ CHANGE DEFAULT PRINTER
The last option is to change/set the default printer. This printer
driver routine comes with 4 default printer types, Epson, HP Laser, Star,
and Okidata.
You can add (Ctrl N) as many as you want.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ Current Default Printer is set to: Okidata ║
╟────────────────────────────────────────────────────────────────────────────╢
║ NAME LINEFEED ║
║─────────────────────────────────────╥──────────────────────────────────────║
║ Epson & Compatibles ║ CHR(10) ║
║ HP Laser & Compatibles ║ CHR(10) ║
║ Star Micro Gemini ║ CHR(10) ║
║ Okidata ║ CHR(10) ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add)
1/4
DAYO Quotes, TJS LAB Page: 37
■ FULL SCREEN EDIT - F2
When entering the printer codes, the string must be in the valid format
or it will not be printed later when requested...
┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐
│ NAME: Epson & Compatibles │
│ LINEFEED: CHR(10) │
│ NORMAL: CHR(27)+CHR(18) │
│ SMALL: CHR(27)+CHR(15) │
│ BOLDON: CHR(27)+CHR(69) │
│ BOLDOFF: CHR(27)+CHR(70) │
│ _6LPI: CHR(27)+CHR(50) │
│ _8LPI: CHR(27)+CHR(48) │
│ PORTRAIT: │
│ LANDSCAPE: │
│ RESET: CHR(27)+CHR(64) │
│ SPEC_STR1: │
│ SPEC_STR2: │
│ SPEC_STR3: │
│ SPEC_STR4: │
│ SPEC_STR5: │
│ RUN_CMD: │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
■ PRINTER DRIVER DATABASE FIELD DEFINITIONS
NAME - Name of printer. Type in anything you wish here
LINEFEED - Code to advance printer one line
NORMAL - Normal font/character size
SMALL - Small font/character size
BOLDON - Bold/Emphasized
BOLDOFF - Bold/Emphasized off
_6LPI - Code to set printer to print 6 lines per inch
_8LPI - Code to set printer to print 8 lines per inch
PORTRAIT - Code to set laser printer to print upright (normal)
LANDSCAPE - Code to set laser printer to print sideways
RESET - Reset printer code
SPEC_STR1 - Any special printer string, ie: print double, skip perforation,
SPEC_STR2 - print very tiny, ...
SPEC_STR3 - "
SPEC_STR4 - "
SPEC_STR5 - "
RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ...
DAYO Quotes, TJS LAB Page: 38
■ MISCELLANEOUS ROUTINES
- The MISC routines is a collection of 17 very useful Database Management
Routines. These routines provide you with the 'ability to do whatever was
left out of the rest of the program...'. These routines were modeled after
dBase (tm) III+/IV functions. Familiarity with dBase will help with the
understanding and execution of these routines.
USE WITH CAUTION!
YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES
YOU CAN ALSO MESS THINGS UP PERMANENTLY!
■ MISC Routines Menu:
DAYO Quotes Version 4.0 TJS LAB ┌───[February 1992]──┐
╔════════════════════╗ │S M T W T F S │
║ MISC ROUTINES ║ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤
╟────────────────────╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6│
║ APPEND FROM ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 7 8 9 10 11 12 13│
║ BROWSE DATABASES ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │14 15 16 17 18 19 20│
║ COPY (.DBF) TO ║ █░ █░ █░ █░ █░ █░ █░ │21 22 23 24 25 26 27│
║ CREATE DATABASE ║ ████▀ █░ █░ █░ ▀███▀ │28 29 30 31 │
║ DELETE RECORDS ║ │ │
║ ERASE FILE ║ └────────────────────┘
║ EXIT TO DOS ║ ╓────────────────────────────────────────────────╖
║ INDEX A DATABASE ║ ║ DAYO QUOTES STATISTICS ║
║ LIST FIELDS ║ ║ DATABASE NAME RECORDS SIZE ║
║ PACK DATABASE ║ ║ INV.DBF Inventory 0 1K ║
║ MODIFY DATABASE ║ ║ QUOTE.DBF Quote Header 10 5K ║
║ RECALL RECORDS ║ ║ QUOTESD.DBF Quote Detail 69 6K ║
║ RETURN TO MENU ║ ║ CUSTOMER.DBF Customers 0 1K ║
║ RUN (DOS COMMAND) ║ ╚════════════════════════════════════════════════╝
║ SIMPLE EDITOR ║ ▄█████▄ ████▄ ▄██▄
║ SORT DATABASE ║░ █░ █░ █░
║ TYPE (PRINT) FILE ║░ █░ █▄▄▄ ▀██▄
║ ZAP DATABASE ║░ █░ █░ █░
╟────────────────────╢ █░ ████▀ ▀██▀
║ Select Option ║
╚════════════════════╝
DAYO Quotes, TJS LAB Page: Page: 39
■ APPEND FROM
- Used to copy records from one database into another database, or to create
records from ASCII files (SDF or DELIMITED).
- The Initial Screen will prompt you to enter the file name of the database
you are to append/copy the data into. At this point, you can either type in
the name of the target database, or ...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
└────────────────────────────────────────────────────────────────────────────┘
- If it exists in the current directory, press enter on an empty prompt to
display all databases to select from.
┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │INVENT.DBF │ 375 │ 09/16/89 │ │
│ │AR.DBF │ 7219 │ 09/16/89 │ │
│ │HISTORY.DBF │ 103 │ 09/16/89 │ │
│ │PERSONS.DBF │ 24271 │ 09/16/89 │ │
│ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
│ │
└───────────────────────────────────────────────────────────────────────────┘
- The next prompt will be to select the type of Append:
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
└──────────────────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: Page: 40
- If you are appending from another database (.DBF) then select 'Standard'.
- Select the SDF option if you are appending from a 'flat' ASCII file.
- Select the DELIMITED option if you are appending from a delimited ASCII
file. Delimited files contain records in which the fields are separated by
commas, and its character fields contained in double quotes...
- If you select a Standard Append, you will then be prompted to enter the name
of the database you wish to get the data from. If you selected the SDF or
DELIMITED options, then enter the file name containing the data to be
appended into your target database.
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into PERSONS.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: PERSON1.TXT │
│ │
│ │
└──────────────────────────────────────────────────────────────────────────┘
- The number of records appended into the target database will be displayed
upon completion of the task...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF From INVENTY.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: INVENTY.DBF │
│ │
│ │
│ │
│ There Were 1 Records Appended Into INVENT.DBF │
│ │
│ │
│ │
│ Press Any Key To Continue... │
│ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: Page: 41
■ BROWSE DATABASES
- Used to edit/view records in a database. Enter the database name you wish to
edit/browse, or if it exists in the current directory, press enter on an
empty prompt to bring up a window box to select from.
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: INVENT.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
- If there exists an index (.NDX or .NTX), with the same name as the database,
it will be utilized... The DAYO Inventory indexes are the exception. They
are automatically set/used.
- An example of a browse screen:
TJS LAB, PO BOX 585366
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ MFG_PART DESC PRICE LIST │
│──────────────────╥────────────────────────────────╥────────────╥───────────│
│ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │
│ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │
│ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │
│ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │
│ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │
│ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │
│ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │
│ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │
│ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │
│ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │
│ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │
│ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │
│ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │
│ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │
│ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │
│ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │
│ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │
├──────────────────╨────────────────────────────────╨────────────╨───────────┤
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
51/60
DAYO Quotes, TJS LAB Page: Page: 42
- To edit a memo field, just highlight the field, and start typing.
* * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING!
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ PRICE LIST YOURPART NOTES │
│───────────────────────╥────────────╥─────────────────╥─────────────────────│
│ 896.16 ║ 1792.32 ║ ║ <Memo> │
│ 1064.19 ║ 2128.38 ║ ║ <Memo> │
│ 672.12 ║ 1344.24 ║ ║ <Memo> │
│ 1736.31 ║ 3472.62 ║ ║ <Memo> │
│ 504.09 ║ 1008.18 ║ ║ <Memo> │
│ 784.14 ║ 1568.28 ║ ║ <Memo> │
│ 1400.25 ║ 2800.50 ║ ║ <Memo> │
┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐
│You can edit memo fields too... │
│ │
│ │
│ │
│ │
│ │
│ │
└───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
- Special keys for 'moving around' the BROWSE screen are:
Left Arrow Key - Move to next field to your left
Right Arrow Key - Move to next field to your right
Ctrl Home - Go to the leftmost field
Ctrl End - Go to the rightmost field (on the end of the record)
Up Arrow - Move highlight to the previous record
Down Arrow - Move highlight to the next record
PgUp - Page up a full screen of records
PgDn - Page down a full screen of records
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end or last record of the file
Ctrl N - Add a record (where applicable)
Ctrl U - Delete a record (where applicable)
F5 - To seek/find a record based upon the active index
Esc - Exit the current operation
- Remember that there are many more fields to the right of the screen. Press
the right arrow key to view them...
DAYO Quotes, TJS LAB Page: Page: 43
■ COPY (.DBF) TO
- Copy records to another (new) database. Use this option to copy select
records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can
also be used to create backups of data (EG: copy to floppy).
┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │HARPS.DBF │ 375 │ 09/16/89 │ │
│ │INVENT.DBF │ 7335 │ 09/16/89 │ │
│ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │
│ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │
│ │AP.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
└────────────────────────────────────────────────────────────────────────────┘
- The next prompt will be to select the type of COPY TO option you want:
┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: INVENT.DBF │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ │
│ Copy Records From INVENT.DBF │
└────────────────────────────────────────────────────────────────────────────┘
- The Standard option is simply creating another database (.DBF). The SDF and
DELIMITED options will create ASCII files. The STRUCTURE option creates a
new database with the same file structure as the initial database (no
records copied).
DAYO Quotes, TJS LAB Page: Page: 44
- The next prompt (optional), requires some knowledge of dBase (tm). This
prompt is requesting the user to enter a condition or filter. If all
records are to be copied, just press Enter on an empty prompt.
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW.DBF │
│ │
│ Enter Condition: │
│ Sample condition: COST > 100 │
│ │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
- This 'Condition' option is useful for coping only specific records into a
new location. Any valid dBase/Clipper statement (as shown next) is
fine...
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW DBF │
│ │
│ Enter Condition: PRICE>0 │
│ Sample condition: COST > 100 │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: Page: 45
- The following window message will appear while the COPY TO routine does
its task:
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW10 │
│ │
│ Enter Condition: PRICE>0 │
│ Sample cond┌───────────────────────────────────────────────┐ │
│ │┌─────────────────────────────────────────────┐│ │
│ CONDITION: ││┌───────────────────────────────────────────┐││ │
│ │││┌─────────────────────────────────────────┐│││ │
│ ││││Hold those camels while I do this COPY TO││││ │
│ │││└─────────────────────────────────────────┘│││ │
│ ││└───────────────────────────────────────────┘││ │
│ │└─────────────────────────────────────────────┘│ │
│ └───────────────────────────────────────────────┘ │
│ Copy Records From SDF To NEW10 │
└────────────────────────────────────────────────────────────────────────────┘
■ CREATE DATABASE
- Create a new database. This routine lets you create entirely new database
structures. At the FIELD_NAME field, enter a unique field name. At the
FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date,
'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the
size/length of the character and/or numeric field. At the FIELD_DEC field,
enter the number of decimals for the numeric field.
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ ║ ║ 0 ║ 0 │
│ ║ ║ ║ │
│ ║ ║ ║ │
┌─────────────│ ║ ║ ║ │────────────┐
│ │ ║ ║ ║ │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
DAYO Quotes, TJS LAB Page: Page: 46
* * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * *
IT IS SLIGHTLY BOTHERSOME
SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING...
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to edit the new database.
This error may even cause your computer to hang!
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will just negate your efforts..
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ NAME ║ C ║ 30 ║ 0 │
│ AGE ║ N ║ 5 ║ 1 │
│ DEAD ║ L ║ 1 ║ 0 │
│ BIRTHDATE ║ D ║ 8 ║ 0 │
┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐
│ │ ║ ║ 0 ║ 0 │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│ ║ ║ ║ │
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
DAYO Quotes, TJS LAB Page: Page: 47
■ DELETE RECORDS
- Delete selected records from databases. The first prompt is for the name of
the database you wish to mark records for deletion. Like many of the other
routines, you can press enter on an empty prompt to bring up all databases
that exist in the current directory:
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│D.DBF │ 259 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/16/89 │
│XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└────────────────────────────────────────────────────────────────────────────┘
- After selecting the database, all its fields will be presented atop the
screen so as to aid the user in entering a condition/filter. The use of the
condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax
is required. Note the use of the Clipper Function: EMPTY().
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐
│ Enter Database Name: TRASH │
│ Delete Records For Condition: EMPTY(PART) │
│ Sample condition: COST > 100 │
│ CONDITION: EMPTY(PART) │
│ Number of Records Deleted: 208 │
│ Press any key to continue... │
└────────────────────────────────────────────────────────────────────────────┘
- The number of records deleted will be displayed upon the screen as depicted
just above...
DAYO Quotes, TJS LAB Page: Page: 48
■ ERASE FILE
- Erase a file (forever!). Use this option with extreme care!
Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY
REMOVED FROM EXISTENCE
NO SECOND CHANCES HERE...
- The first prompt is for the file name. You can press enter on an empty
prompt to bring up a window selection of all files in the current directory.
┌────────────────────────┐
┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘
│BKDOOR.DOC │ 37029 │ 09/17/89 │
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│D.DBF │ 259 │ 09/16/89 │
│D.DBT │ 512 │ 09/16/89 │
│DAYOBK.BAK │ 36879 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
│DAYOBK.OBJ │ 35585 │ 09/16/89 │
│DAYOCAL.MAP │ 35 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│DDD.DBT │ 512 │ 09/16/89 │
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
- To ERASE a file, just highlight it, then press Enter...
■ EXIT TO DOS
- This option will close all open files and databases and exit to DOS without
having to return to the main menu exit routine.
DAYO Quotes, TJS LAB Page: Page: 49
■ INDEX A DATABASE
- You will be prompted to select the database you wish to index. After
selecting the database, by typing in the name or pressing Enter on an empty
prompt (then selecting from the window), you will be given a listing of all
fields in that database atop the screen.
┌────────[ PICK A DATABASE ]───────────┐.
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DAD.DBF │ 259 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SPW.DBF │ 7335 │ 09/16/89 │
│SOW.DBF │ 103 │ 09/16/89 │
│BOY.DBF │ 24387 │ 09/17/89 │
│SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
- You will now be prompted to enter the name of the Index File. It will be
(by default), named exactly the same as the selected database, with the
exception of the extension. This will default to .NDX or .NTX depending on
whether you linked NDX.OBJ with your application.
*** Remember that the BROWSE routine only looks at indexes with the same
name as the database.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
└───────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: Page: 50
- At the prompt for the index key, enter a field name, or a valid
dBase/Clipper expression.
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
│ Enter the Key Expression: PART+MFG_PART │
└───────────────────────────────────────────────────────────────┘
■ LIST FIELDS
- List fields to screen or printer. This routine is a great tool for providing
simple reports and lists. The first prompt will be for the database you wish
to work with. Type the name of the file, or press Enter on an empty prompt
to bring up a window of all databases in the current directory for
selection.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│INVEND.DBF │ 259 │ 09/16/89 │
│INVENT.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SOMEDAY.DBF │ 7335 │ 09/16/89 │
│TANGO.DBF │ 103 │ 09/16/89 │
│AP.DBF │ 24387 │ 09/17/89 │
│BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: Page: 51
- The next prompt is for a condition or filter. This makes it possible to list
only specific records that meet that condition you enter. The condition must
be a valid dBase/Clipper expression, or none (to list all).
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌─────────────────────────────────────────────────────┐
│ Enter Filter: │
│ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
└─────────────────────────────────────────────────────┘
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: │
│ │
└───────────────────────────────────────────────────────────────┘
- A window box appears next displaying all the fields in the selected database
and an option to list all fields. Highlight any combination of fields ( or
ALL) that you want listed.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║ ├─────────────────┤ ║
╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝
│RECNO() │
│MFG_PART │
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: Page: 52
- The fields you select will be displayed at center top of screen. Press Esc
to exit the "PICK THE FIELDS YOU WANT LISTED" window.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
- At the next prompt, you can send the list to the SCREEN, PRINTER OR
FILE.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│DESC┌──────────────────────────────────────────────────────────────────┐
│PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │
│LIST│ │
│YOUR└──────────────────────────────────────────────────────────────────┘─┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: Page: 53
- The list is very simple, and if displayed onto the screen, may look like the
following:
PART MFG_PART PRICE
4523 0.00
DAYO9S 41926 1904.34
DAYO10S 13564 616.11
DAYOCOMP 45625 2072.37
DAYOALLS 43159 1960.35
INDEXER 50558 2296.41
INDEXERS 51791 2352.42
5 DEMO 4932 224.04
DAYO13S 20963 952.17
MENUS 53024 2408.43
OFFSITEP 56724 2576.46
ONSITEP 57957 2632.47
DAYO2S 24662 1120.20
DAYO9 40693 1848.33
DAYO10 12331 560.10
DAYOCAL$ 44392 2016.36
DAYO13 19730 896.16
DAYO2 23429 1064.19
DAYO11 14797 672.12
DAYO8 38227 1736.31
DAYO1 11098 504.09
DAYO12 17264 784.14
DAYO5 30828 1400.25
......PRESS ANY KEY TO CONTINUE......
■ MODIFY DATABASE
- Change the fields/structure of a database. You can add new fields, delete
fields, change the length and type of field in any of the databases. At the
FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter
a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M'
for memofield. At the FIELD_LEN field, enter the size/length of the
character and/or numeric field. At the FIELD_DEC field, enter the number of
decimals for the numeric field.
********************************************************
*** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST ***
*** IT IS SLIGHTLY BOTHERSOME SORRY! ***
********************************************************
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to access the database.
This error may even cause your computer to hang!
DAYO Quotes, TJS LAB Page: Page: 54
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will just negate your efforts..
■ PACK DATABASE
- Pack a database (removed deleted records). This option will permanently
remove any records marked for deletion. This is another routine you should
use with great care! As in many of the other of the routines, you will be
prompted to enter the name of the database you wish to pack. Enter the name
or press Enter on an empty prompt to view the window.
┌─────┐
│PACK!│
└─────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│GOODDATA.DBF │ 259 │ 09/16/89 │
│HAP.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│LOIN.DBF │ 103 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/17/89 │
│FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
- After selecting the database, you will be prompted to respond with a Yes or
No (to Pack or not to Pack...). This is the last chance you have to change
your mind...
┌──────────────────────────────────────────────────────────────────────────┐
│ PACK TOM3 │
│ Are you sure you want to PACK (remove deleted records) ? N │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: Page: 55
■ RECALL RECORDS
- Recalls records previously marked for deletion. This option is identical to
the DELETE RECORDS option discussed earlier...
■ RETURN TO MENU
- Returns to the procedure that called MISC Routines.
■ RUN (DOS COMMAND)
- Run a DOS command (EG: dir/w). This option is helpful in that it allows
you to run programs at the DOS level (within memory constraints).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN CD\DOS │
└───────────────────────────────────────────────────────────────────────────┘
- One useful option is to type and Enter: COMMAND at this prompt. You will be
running another DOS Shell totally out of the program (it still is in memory
though).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN COMMAND │
└───────────────────────────────────────────────────────────────────────────┘
- Press and Enter: EXIT to return to your Clipper Application.
EG:
The COMPAQ Personal Computer MS-DOS
Version 3.31
(C) Copyright Compaq Computer Corp. 1982, 1987
(C) Copyright Microsoft Corp. 1981, 1987
C:\KISBBS>EXIT
DAYO Quotes, TJS LAB Page: Page: 56
■ SIMPLE EDITOR
- A simple editor and word processor. Use this option to create and read
simple TEXT files. File size is limited to your machines capabilities or
32,000k. The first prompt is for the name of the file you wish to edit. Type
in the name, or press Enter on an empty prompt to bring up a window option
box containing all files in the current directory.
┌────────────────────────┐
┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐
│ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │
│ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │
└────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
│DEMO.MAP │ 7780 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
- *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...),
so be careful at what you select for viewing/editing.
- If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those
changes. If you exit with an Esc, all changes will be lost!
┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐
│CLIPPER demo │
│CLIPPER MISC │
│KWAIT 10 │
│LIB MISC-+MISC,MISC.LST,MISC │
│KWAIT 10 │
│TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │
│KWAIT 10 │
│DEMO │
└────────────────────────────────────────────────────────────────────────────┘
Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0
DAYO Quotes, TJS LAB Page: Page: 57
- Special keys for 'moving around' the SIMPLE EDITOR screen are:
Left Arrow Key - Move to your left
Right Arrow Key - Move to your right
Ctrl Home - Go to the top, leftmost corner of window
Ctrl End - Go to the bottom, rightmost corner of window
Up Arrow - Move up one line
Down Arrow - Move down one line
PgUp - Page up a full screen
PgDn - Page down a full screen
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end of the file
* F2 - Import text from a text file
* Ctrl W - Save Changes and Exit
* Esc - ABORT Changes and Exit
The margin may exceed the boundaries on the right side of the screen, but
the text is easily accessed using the special keys above...
■ SORT DATABASE
- This option takes a database, sorts it, and copies the result into a new
database. The first prompt is for the name of the database you want to sort.
Enter the name, or press Enter on an empty prompt to bring up a window box
containing all databases in the current directory.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DOG.DBF │ 259 │ 09/16/89 │
│CAT.DBF │ 375 │ 09/16/89 │
│CAR.DBF │ 195 │ 09/17/89 │
│BAM.DBF │ 7335 │ 09/16/89 │
│HARP.DBF │ 103 │ 09/17/89 │
│TRAIN.DBF │ 24387 │ 09/17/89 │
│HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└───────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: Page: 58
- The next prompt is for the name of the database you will be creating with
the sorted data.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: INVNET.DBF │
│ Enter Name of Sorted File: INVNET1.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
- The next prompt is for the sort field (limited to 1 field)...
╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: TOM.DBF │
│ Enter Name of Sorted File: TOM1.DBF │
│ Enter the Key Expression: PART │
└───────────────────────────────────────────────────────────────┘
■ TYPE (PRINT) FILE
- Prints an ASCII/text file to screen or printer. The first prompt is for the
file name.
┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐
│ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │
│ Press Enter/Return on an empty field to get a current directory listing. │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: Page: 59
- The display of the file (any type), is continuous, but can be paused by
any key (except the Enter & Esc keys). Pressing the Enter key will slow the
printing of the file onto the screen. Press Esc to Abort the display... A
sample display:
FUNCKEY...........MISC FUNIQUE...........MISC
FZAP..............MISC GET_PIC1..........MISC
ISDATA............MISC ISDBF.............MISC
MENU_KEY..........MISC MISC..............MISC
OKFILE............MISC PACKIT............MISC
PICKDBF...........MISC PROCLIST..........MISC
SHOW_INS2.........MISC STATLINE2.........MISC
TOG_INS2..........MISC XKEY_CLEAR........MISC
XKEY_NORM.........MISC XMEMO.............MISC
MISC
BKDOOR BROWSEIT CENTER1 COLORSET
DBFUNCT DBFUNCT6 EDITOR FACHOICE
FAPPEND FCOPY2 FDBF1 FDELETE
FERASE FILESZ FILE_UDF FILT
FINDER FINDEX FMAKEDB FMODYDB
FNEW FRECALL FRUN FSCROLL1
FSORT FTYPEIT FUNCKEY FUNIQUE
FZAP GET_PIC1 ISDATA ISDBF
MENU_KEY MISC OKFILE PACKIT
PICKDBF PROCLIST SHOW_INS2 STATLINE2
TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO
PRESS ANY KEY TO CONTINUE...
■ ZAP DATABASE
- Totally erase all records in database (forever!). When you
want to remove every record from a database, then use this option. Use with
EXTREME CAUTION! The first prompt is for the file name. Enter the name of
the database you are to 'clean out', or press Enter to select the database
from a window containing all databases in the current directory.
DAYO Quotes, TJS LAB Page: Page: 60
┌────┐
│ZAP!│
└────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DENVER.DBF │ 259 │ 09/16/89 │
│OHIO.DBF │ 375 │ 09/16/89 │
│NEWYORK.DBF │ 195 │ 09/17/89 │
│MONTANA.DBF │ 7335 │ 09/16/89 │
│SC.DBF │ 259 │ 09/17/89 │
│EARS.DBF │ 103 │ 09/17/89 │
│FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐
│MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │
│CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │
└──────────────┴────────────┴──────────┘───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
- You will be prompted one last time as to whether you still want to ZAP the
selected database. Press Y for Yes, N for No...
┌────┐
│ZAP!│
└────┘
┌──────────────────────────────────────────────────────────────────────────┐
│ ZAP TRASH │
│ Are you sure you want to ZAP (remove all records permanantly) ? N │
│ │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: 61
■ HELP SCREENS
- While in the browse screens, some of the option windows, and in the SIMPLE
EDITOR, pressing the F1 key, will display a help screen.
- BROWSE help:
┌──────────────────────[ DAYOQUO HELP: DBEDIT, 0, ]─────────────────────────┐
│ │
│- Special keys for 'moving around' the BROWSE screen are: │
│ │
│ Left Arrow Key - Move to next field to your left │
│ Right Arrow Key - Move to next field to your right │
│ Ctrl Home - Go to the leftmost field │
│ Ctrl End - Go to the rightmost field (on the end of the record)│
│ Up Arrow - Move highlight to the previous record │
│ Down Arrow - Move highlight to the next record │
│ PgUp - Page up a full screen of records │
│ PgDn - Page down a full screen of records │
│ Ctrl PgUp - Go to the beginning of the file │
│ Ctrl PgDn - Go to the end or last record of the file │
│ Ctrl N - Add a record (where applicable) │
│ Ctrl U - Delete a record (where applicable) │
│ F5,F6,F7 - To seek/find a record based upon the active index │
│ Esc - Exit the current operation │
│ │
│ Remember that there are many more fields to the right of the screen. │
│ Press the right arrow key to view them... │
└────────────────────────────────────────────────────────────────────────────┘
- Option Box Help:
┌───────────────────────[ DAYOQUO HELP: ACHOICE, 0, ]───────────────────────┐
│ │
│ │
│ │
│ │
│ - Special keys for 'moving around' the Option Box are: │
│ │
│ Up Arrow - Move up one option │
│ Down Arrow - Move down one option │
│ PgUp - Page up multiple records │
│ PgDn - Page down multiple records │
│ Esc - ABORT and Exit │
│ │
│ │
│ After highlighting the option you desire, press Enter... │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO Quotes, TJS LAB Page: 62
- Editor help:
┌──────────────────────[ DAYOQUO HELP: MEMOEDIT, 0, ]───────────────────────┐
│ │
│ - Special keys for 'moving around' the EDITOR screen are: │
│ │
│ Left Arrow Key - Move to your left │
│ Right Arrow Key - Move to your right │
│ Ctrl Home - Go to the top, leftmost corner of window │
│ Ctrl End - Go to the bottom, rightmost corner of window │
│ Up Arrow - Move up one line │
│ Down Arrow - Move down one line │
│ PgUp - Page up a full screen │
│ PgDn - Page down a full screen │
│ Ctrl PgUp - Go to the beginning of the file │
│ Ctrl PgDn - Go to the end of the file │
│ Ctrl W - SAVE Changes and Exit │
│ Esc - ABORT Changes and Exit │
│ F2 - Import another text file into your document │
│ │
│ The margin may exceed the boundaries on the right side of the screen, │
│ but the text is easily accessed using the special keys above... │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
■ EXPANDED HELP
After Version 1.3, expanded help routines were added to all DAYO modules.
At almost all prompts and menus you can press F1 for help. Help can be a
function key message as displayed on previous page, a message that you have
created (user defined & inputted), or the ability to read the documentation
on the screen (saves paper).
DAYO Quotes, TJS LAB Page: 63
■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
If you press F1 and no user defined & inputted message exists for that
section of the program you are currently in you will receive a message to
this effect, and then a blank/empty screen.
The editing keys for this option are the same as for the Simple Editor
(previous page).
DAYO Quotes Version 4.0 TJS LAB ┌───[February 1992]──┐
┌──────[ DAYO HELP Called by Program: DAYOQUO Variable: OPT ]───────┐
│ │
│ │
│ │
│ │
│ │
│ │
│ ╔════════════════════════════════════════════════════════╗ │
│ ║ No Online Help Messages Exist for this prompt... ║ │
│ ║ ║ │
│ ║ You can type in any help message you wish, or ║ │
│ ║ press F1 to view the document for DAYOQUO. ║ │
│ ║ ║ │
│ ║ ║ │
│ ║ Press any key to continue... ║ │
│ ╚════════════════════════════════════════════════════════╝ │
│ │
│ │
├───────────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │
└───────────────────────────────────────────────────────────────────────────┘
If you wish to input anything at this point, just type whatever you
wish, remembering to press Ctrl W to save all changes. Pressing Esc will
not save ANY changes ( all effort you put into writing a help message will
be lost! ).
DAYO Quotes, TJS LAB Page: 64
DAYO Quotes Version 4.0 TJS LAB ┌───[February 1992]──┐
┌───────[ DAYO HELP Called by Program: DAYOQUO Variable: OPT ]───────┐
│ │
│ │
│ │
│ │
│ Type in anything you wish about this portion of the program! │
│ │
│ The length of this file can be many pages... │
│ │
│ Be sure to press Ctrl W to save any changes/additions you make to this │
│ screen. │
│ │
│ │
│ │
│ │
│ │
│ │
├────────────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │
└────────────────────────────────────────────────────────────────────────────┘
■ VIEW DOCUMENTATION ONSCREEN
To view the documentation for the module you are in, it must first exist
in the current directory. Document files are named the same as the module,
and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYOQUO.DOC.
Press F1 in the User Defined & Inputted Help Message screen to display the
document (user manual). The special keys in this option are displayed in the
Help Screen (press F1 again) for this option:
╔══════════════════════════════════════════════════════════════════════════╗
║ While viewing the document for DAYOQUO the keyboard is configured ║
║ as followed: ║
║ ║
║ Esc Exit ║
║ F5 Find a string. This search is not case sensitive ║
║ Examples: Page: 50 ║
║ INTRODUCTION ║
║ REPORTS ║
║ Home Return to the beginning of the document ║
║ End Go to the bottom of the document ║
║ PgUp Page up ║
║ ║
║ Any other key moves acts like PgDn (page down) ║
║ ║
║ Press any key to continue... ║
╚══════════════════════════════════════════════════════════════════════════╝
DAYO Quotes, TJS LAB Page: 65
■ DATABASE STRUCTURE
Database: QUOTES.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 QUOTE Numeric 6 1 6
2 CUSTOMER Numeric 6 7 12
3 SHIPNAME Character 30 13 42
4 SHIPADDR1 Character 30 43 72
5 SHIPADDR2 Character 30 73 102
6 SHIPCITY Character 17 103 119
7 SHIPSTATE Character 2 120 121
8 SHIPZIP Character 10 122 131
9 PHONE Character 14 132 145
10 TYPE Character 3 146 148
11 TERMS Character 20 149 168
12 TERMS2 Character 20 169 188
13 AMOUNT2 Numeric 10 2 189 198
14 SHIPPER Character 20 199 218
15 FOB Character 30 219 248
16 DATE Date 8 249 256
17 TIME Character 8 257 264
18 REG Character 3 265 267
19 BY Character 30 268 297
20 SALESPER Character 3 298 300
21 CUST_PO Character 15 301 315
22 SC Logical 1 316 316
23 BO Numeric 6 317 322
24 TAXRATE Numeric 6 4 323 328
25 TAXES Numeric 10 2 329 338
26 ADJUST Numeric 10 2 339 348
27 FREIGHT Numeric 10 2 349 358
28 SUBTOTAL Numeric 10 2 359 368
29 OPEN Logical 1 369 369
30 PRINTED Logical 1 370 370
31 PAID Numeric 10 2 371 380
32 CLASS Character 3 381 383
33 COMMENT Character 50 384 433
─────
Total 434
DAYO Quotes, TJS LAB Page: 66
Database: QUOTESD.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 QUOTE Numeric 6 1 6
2 ITEM Character 12 7 18
3 DESC Character 30 19 48
4 DESC2 Character 30 49 78
5 QTY Numeric 7 79 85
6 PRICE Numeric 10 2 86 95
7 COST Numeric 10 2 96 105
8 TAXABLE Logical 1 106 106
9 DATE Date 8 107 114
10 CUSTOMER Numeric 6 115 120
11 CLASS Character 3 121 123
─────
Total 124
DAYO Quotes, TJS LAB Page: 67
Database: INV.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 ITEM Character 12 1 12
2 DESC Character 30 13 42
3 DESC2 Character 30 43 72
4 ONHAND Numeric 7 73 79
5 ALLOCATED Numeric 7 80 86
6 ONORDER Numeric 7 87 93
7 BO Numeric 7 94 100
8 SOLDPTD Numeric 7 101 107
9 SOLDYTD Numeric 7 108 114
10 VENDITEM Character 12 115 126
11 VENDOR Character 10 127 136
12 DATE Date 8 137 144
13 LASTDATE Date 8 145 152
14 COST Numeric 10 2 153 162
15 AVGCOST Numeric 10 2 163 172
16 REALCOST Numeric 10 2 173 182
17 RETAIL Numeric 10 2 183 192
18 PRICE Numeric 10 2 193 202
19 PRICE1 Numeric 10 2 203 212
20 PRICE2 Numeric 10 2 213 222
21 PRICE3 Numeric 10 2 223 232
22 PRICE4 Numeric 10 2 233 242
23 PRICE5 Numeric 10 2 243 252
24 STOCKLEVEL Numeric 7 253 259
25 TYPE Character 3 260 262
26 CLASS Character 3 263 265
27 TAXABLE Logical 1 266 266
28 SERIALNO Logical 1 267 267
29 WEIGHT Numeric 8 2 268 275
30 UNIT Character 3 276 278
31 UNITQTY Numeric 7 279 285
32 PACKQTY Character 6 286 291
33 BOM Logical 1 292 292
34 LOCATION Character 3 293 295
────────── ─────
Total 296
DAYO Quotes, TJS LAB Page: 68
Database: CUSTOMER.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 CUSTOMER Numeric 6 1 6
2 NAME Character 30 7 36
3 ATTN Character 30 37 66
4 ADDR1 Character 30 67 96
5 ADDR2 Character 30 97 126
6 CITY Character 22 127 148
7 STATE Character 2 149 150
8 ZIP Character 10 151 160
9 SHIPNAME Character 30 161 190
10 SHIPADDR1 Character 30 191 220
11 SHIPADDR2 Character 30 221 250
12 SHIPCITY Character 22 251 272
13 SHIPSTATE Character 2 273 274
14 SHIPZIP Character 10 275 284
15 PHONE Character 14 285 298
16 SALESPER Character 3 299 301
17 TAXRATE Numeric 5 3 302 306
18 TERMS Character 20 307 326
19 SHIPPER Character 20 327 346
20 DATE Date 8 347 354
21 LASTDATE Date 8 355 362
22 TYPE Character 3 363 365
23 CLASS Character 3 366 368
24 PBM Numeric 6 3 369 374
25 PBL Numeric 6 3 375 380
26 SALESPTD Numeric 10 2 381 390
27 SALESYTD Numeric 10 2 391 400
28 DUE Numeric 10 2 401 410
29 PAID_PURC Numeric 10 2 411 420
30 LIMIT Numeric 10 2 421 430
31 ACTIVE Logical 1 431 431
─────
Total 432
DAYO Quotes, TJS LAB Page: 69
Database: TEMPLATE.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 TEMPLATE Numeric 6 1 6
2 ITEM Character 12 7 18
3 DESC Character 30 19 48
4 QTY Numeric 7 49 55
5 PRICE Numeric 10 2 56 65
6 DATE Date 8 66 73
─────
Total 74
Database: TAXCODE.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 TAXCODE Character 1 1 1
2 TAXRATE Numeric 5 3 2 6
─────
Total 7
Database: TYPE.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 TYPE Character 3 1 3
2 DESC Character 30 4 33
─────
Total 34
Database: TERMS.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 TERMS Character 20 1 20
─────
Total 21
Database: SHIPPER.DBF
Field Field name Type Width Dec Start End
───── ────────── ───────── ───── ─── ───── ───
1 SHIPPER Character 20 1 20
─────
Total 21
DAYO Quotes, TJS LAB Page: 70
■ DATA DICTIONARY
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
ACTIVE L 1 0 CUSTOMER.DBF Not used by DAYO QUOTES
ADDR1 C 30 0 CUSTOMER.DBF 1st line of the customers address
ADDR2 C 30 0 CUSTOMER.DBF 2nd line of the customers address
ADJUST N 10 2 QUOTES.DBF Invoice adjustments amount
AMOUNT2 N 10 2 QUOTES.DBF 2nd Terms Amount
ATTN C 30 0 CUSTOMER.DBF Name of the customer contact/POC
BY C 30 0 QUOTES.DBF Operator Name
CITY C 22 0 CUSTOMER.DBF Customers city
CLASS C 3 0 CUSTOMER.DBF Your customer classification code
COMMENT C 50 0 QUOTES.DBF Invoice/Quote comment field
COST N 10 2 QUOTESD.DBF Cost to you (from vendor) for an
item
CUSTOMER N 6 0 QUOTES.DBF Customer number
CUSTOMER.DBF
CUST_PO C 15 0 QUOTES.DBF Purchase Order of the customer/
client
DATE D 8 0 QUOTESD.DBF Date the record was created
TEMPLATE.DBF
QUOTES.DBF
CUSTOMER.DBF
DESC C 30 0 QUOTESD.DBF Item Description
TYPE.DBF Type Description
TEMPLATE.DBF Item Description
DESC2 C 30 0 QUOTESD.DBF 2nd/Expanded Item Description
DUE N 10 2 CUSTOMER.DBF Balance Due for products purchased
FOB C 30 0 QUOTES.DBF Freight on Board
FREIGHT N 10 2 QUOTES.DBF Invoice freight amount
ITEM C 12 0 QUOTESD.DBF Item number. Sometimes referred
TEMPLATE.DBF to as a part number, product and/
or line item
LASTDATE D 8 0 CUSTOMER.DBF Date of last transaction
LIMIT N 10 2 CUSTOMER.DBF Credit limit
NAME C 30 0 CUSTOMER.DBF 'Bill To' Name of the Customer
OPEN L 1 0 QUOTES.DBF Not used with DAYO Quotes, but is
a flag to denote whether the
record should be deleted/removed
PAID N 10 2 QUOTES.DBF Amount of money collected from the
customer/client
PAID_PURC N 10 2 CUSTOMER.DBF Amount collect for invoices
PBM N 6 3 CUSTOMER.DBF Price Book Margin Points
PBL N 6 3 CUSTOMER.DBF Price Book Discount of List
PHONE C 14 0 QUOTES.DBF Customer/client Telephone number
CUSTOMER.DBF
PRICE N 10 2 QUOTESD.DBF Cost to the customer/client
TEMPLATE.DBF
PRINTED L 1 0 QUOTES.DBF Flag to denote that the invoice
has been printed
QTY N 7 0 QUOTESD.DBF Quotes quantity
TEMPLATE.DBF Template quantity
DAYO Quotes, TJS LAB Page: 71
Field Name Type Len Dec Database Description/Comments
────────── ──── ─── ─── ──────────── ──────────────────────────────────
QUOTE N 6 0 QUOTESD.DBF Quotes number
QUOTES.DBF
REG C 3 0 QUOTES.DBF Not used by DAYO Quotes
SALESPER C 3 0 CUSTOMER.DBF Sales person responsible for the
QUOTES.DBF invoice/quote
SALESPTD N 10 2 CUSTOMER.DBF Total sales this period
SALESYTD N 10 2 CUSTOMER.DBF Total sales this year
SC L 1 0 QUOTES.DBF Ship Complete flag
SHIPADDR1 C 30 0 CUSTOMER.DBF Ship To address line 1
QUOTES.DBF
SHIPADDR2 C 30 0 CUSTOMER.DBF Ship To address line 2
QUOTES.DBF
SHIPCITY C 17 0 CUSTOMER.DBF Ship To city
QUOTES.DBF
SHIPNAME C 30 0 CUSTOMER.DBF Ship To name
QUOTES.DBF
SHIPPER C 20 0 QUOTES.DBF Shipper/method of shipment
SHIPPER.DBF
CUSTOMER.DBF
SHIPSTATE C 2 0 CUSTOMER.DBF Ship To state
QUOTES.DBF
SHIPZIP C 10 0 QUOTES.DBF Ship To zip code
CUSTOMER.DBF
STATE C 2 0 CUSTOMER.DBF Customers state
SUBTOTAL N 10 2 QUOTES.DBF Subtotal of Detail line items
TAXABLE L 1 0 QUOTESD.DBF If set to 'Y' (true), then the
item is taxable
TAXCODE C 1 0 TAXCODE.DBF Tax code which relates to a
tax rate
TAXES N 10 2 QUOTES.DBF Total taxes for an invoice/quote
TAXRATE N 5 3 TAXCODE.DBF Tax rate to be charged a customer/
QUOTES.DBF client
CUSTOMER.DBF
TEMPLATE N 6 0 TEMPLATE.DBF Template number
TERMS C 20 0 CUSTOMER.DBF Method of payment for invoices
TERMS.DBF
QUOTES.DBF
TERMS2 C 20 0 QUOTES.DBF 2nd Terms Code
TIME C 8 0 QUOTES.DBF Time 'HH:MM:SS' that a transaction
took place
TYPE C 3 0 TYPE.DBF Type of invoice. For example, a
QUOTES.DBF regular sales would be 'REG', a
CUSTOMER.DBF refund would be 'Ref'
ZIP C 10 0 CUSTOMER.DBF Customers zip code
DAYO Quotes, TJS LAB Page: 72
■ DAYO QUOTES MAINTENANCE & QUIRKS
- After using DAYO Quotes for a any period of time, you will need to 'clean
out' deleted and unneeded Quotes from the databases: QUOTES.DBF and
QUOTESD.DBF. This task can be accomplished by deleting the records from a
browse screen, then performing the 'PACK' option from the MISC ROUTINES.
Prior to performing this 'clean up', be sure to do a good backup of the
Quotes databases. The backup is especially important since you will be
permanently removing the records.
- On occasion (maybe an under statement), index files will get corrupted,
especially on networks. To 'fix' a corrupted index requires that everyone
'get out of' the DAYO databases, and then perform a reindexing (actually a
recreation of the indexes). The reindex is accomplished by running the DAYO
Quotes program with a parameter of 'INDEX' (or using DAYO X).
ie:
C:\>DAYOQ INDEX
- If you are on a multiuser network, you must 'flag' (change file attributes)
of all files to make them sharable, readable and writable. Note that the
command/program 'flag' may be called by a different name on your network.
ie:
E:\>FLAG *.NTX SRW
or just to be safe, go ahead and flag all files in the DAYO directory:
E:\>FLAG *.* SRW
- Indexes are recreated once every day. This is automatically performed by the
first user to run DAYO Quotes. This process will take more time as your
files get larger. This process should take place daily, but you can run it
at night with a batch file that waits until after midnight (ie: DAYO Clock),
or a with most scheduling programs. All other users and computers must be
out of the databases, or the procedure will not occur properly. Remember to
'flag' the files sharable, readable and writable.
- Backups of your data and configuration files should take place daily! You
have no doubt heard many scare stories. They are all true! The key files
that need to be backed up all have the extension of .DBF, and .CFG. The
.DBF files are your databases. The .CFG file(s) contain your configuration
information (as seen in the Configuration module).
DAYO Quotes, TJS LAB Page: 73
- If you are on a network, It is NOT recommended that you use dBase III+ with
the databases. It may write an end of file marker not always recognized by
DAYO. Appending additional records to the database after this point often
leads/creates a 'bad record' in the database.
- If you must use dBase (tm) with DAYO Quotes, and you are on a PC based
network/LAN, be sure to SET EXCLUSIVE OFF before you open ANY databases.
This will allow the opened databases to be shared, and more importantly,
prevent a user (or all users!) from 'crashing'!
- If you require an additional decimal for your taxrate (ie: 0.0625), then
you will have to modify the TAXRATE field in the databases TAXCODES.DBF,
INVOICE.DBF, QUOTES.DBF, CUSTOMER.DBF, ARH.DBF. Use the MODIFY DATABASE
option in the MISC ROUTINES to change the length from 5 to 6, and the
number of decimals from 3 to 4.
┌───────[ MODIFY STRUCTURE: TAXCODE.DBF ]─────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│════════════╦════════════╦═══════════╦═══════════│
│ TAXCODE ║ C ║ 1 ║ 0 │
│ TAXRATE ║ N ║ 6 ║ 4 │
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
│ ║ ║ ║ │
│════════════╩════════════╩═══════════╩═══════════│
│ Press Enter to edit any field... │
└───────[PRESS Ctrl W TO SAVE AND EXIT]─────────┘
DAYO Quotes, TJS LAB Page: 74
■ TJS 'Computer' LAB
TJS LAB is an association of programmers and technicians that produce
customized, multiuser software for the PC based network (ie: Novell and
others). Our specialties include Inventory Control, PC Communications/EDI,
Management, Reports (standard and graphic), Data Conversions, and
Accounting (A/R, A/P).
A unique feature of TJS LAB is that our software is by default, multiuser.
'Standalone' applications are the exception! All our applications are
written in Clipper, Basic, or C (preferably Basic or Clipper). We will
license all our application source codes. We produce applications that work,
are easy to use, and are inexpensive!
Want a change?
Want an enhancement!
Want a completely new product/application?
Want to make your idea a reality?
Custom/contract programming, by TJS LAB, and our associates is available.
Standard rate is $50.00 per hour (our sites). Guaranteed quality and timely
work is our number one policy.
We make program enhancements/changes/fixes at our location(s), but can/do
make 'house calls' via special software and a modem.
Write us at:
TJS LAB
PO Box 585366
Orlando, Florida 32858-5366
Or call us (8:00 am - 5:00 pm EST):
(407) 291-3960
* Note that TJS LAB, nor any of the associates accept/take any support
calls for unregistered/purchased products.
